powerbi desktop and sql server analysis service

[Anonymous]

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.can anyone suggests me a solution as how to open the same.Should I need any other credentials regarding to server?Thank you for your time.

Regards

Rishi

[BGZG]

Hi,

I am trying to connect SCSM analysis service which is unfortunately om SQL 2008 RS server. I understand that it does not support live connection, but should I be able to use import?  I do not have any error to connect , but I cannot expend anything under DWASDAtabase. I can connect via SQL Management studio and I can browse all data. I asked SQL guys to restart analysis service and sql browsing service but it did not do any good. I am new with power BI, just start it yesterday to do some testing and i think I was able to browse it yesterday.

Sql guys cannot see any error on their side. Any idea?

[BGZG]

I thought I posted a new quesstion , I guess I reply by mistake.

[Seth_C_Bauer · Accepted solution]

@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]

Thanks for your quick reply....

[v-yuezhe-msft]

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