Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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::
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
I am already using the v 18.8 SSMS
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.