Forum Discussion
error browsing or querying PBI model in SSMS
Hi,
I tried to query a PBI data model from SSMS .I could connect to it via server type: Analysis service and server name as "powerbi://api.powerbi.com/v1.0/myorg/Manufacturing" with AAD authentication.I was also able to see all the datasets within the workspace ,however,the problem is when i click on browse or script as DAX,i get errors.I dont understand what is cause.
Below is the error i get when i browse::
3 Replies
Hey Anonymous ,
make sure you are using the latest SSMS version that is mentioned in this article: Announcing the general availability of read/write XMLA endpoints in Power BI Premium | Microsoft Power BI Blog | Microsoft Power BI
Maybe, the error and an older version of SSMS relate to each other.
Regards,
Tom
Hey Anonymous ,
I'm not familiar with this error message, but one final check, I assume you have enabled XMLA read/write either for the workload of the capacity or for the Premium Per User setting?
Regards,
Tom
