Share via

The Excel Power Pivot data model cannot be connected by DaxStudio add-in

boblee 1 Reputation point
2022-08-10T07:26:20.267+00:00

Because often need to use the DaxStudio add-in to connect to the Excel Power Pivot data model to assist in query processing, but now DaxStudio can't connect to the PP data model since 2022/7/30. The error is shown in the following figure:
229845-image.png

The current Excel is a 365 home preview version, while the other 365 version and the Power BI data model can still be properly connected by DaxStudio.
Please professional help to tell us how to solve this problem, thank you very much!

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Install, redeem, activate | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ceasar Chen_MSFT 4,486 Reputation points
    2022-08-16T08:29:30.52+00:00

    Hi,
    In this case, it is recommended that you change the version and do not use the preview version, which may have more features than the official version, but its compatibility and stability are not very good.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.