Connect to Analysis instance of PBI desktop

We could connect to Analysis instance running 1200 comptability level through Power BI desktop

Once u have some data imported into the PBI desktop model navigate to

%LocalAppData%\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces

and look for msmdsrv.port text file to find the port number the PBI desktop is using for running the Analysis server under the cover.

Then u can connect the the data model either through Excel or SSMS and browse the model

Like what you read? Give Dheeraj Vatti a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.