Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

powerbi desktop and sql server analysis service

Dear Team, I am new to pwer bi desktop . One of my client send me a .pbix file for a rework but as soon as I open it in using power bi desktop it says unable to connect to analysis services server.c...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous You would need to have access to the Server/SSAS instance... The easiest approach is probably trying to speak with the client about remoting into a VM or machine in which you have access to the Desktop file. As long as you have permissions on the SSAS instance as well, you should be able to see it then.

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks for your quick reply....

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous

Just add more information here. In the case that your client connects to SQL Server Analysis Service via “Connect live” option from Power BI Desktop, when the client sends PBIX file to you , you will not able to open the PBIX file unless you have access to the  SQL Server Analysis Service instance.

However, if your client connects to SQL Server Analysis Service via “Import data” option from Power BI Desktop as shown in the following screenshot, when the client sends PBIX file to you, you can open the PBIX file without issues and you don't need access to the  SQL Server Analysis Service instance. You can also suggest the client create PBIX file by connecting to SSAS via “Import data” option next time.


Thanks,
Lydia Zhang