topic Re: Need Help- Analyse in excel issue in Report Server

Need Help- Analyse in excel issue

shwets47 — Wed, 30 Aug 2017 15:57:02 GMT

Hi Guys,

I have an issue that I have been trying to resolve. I have a powerbi report that my client needs to analyse in excel. Hence did some slice and dice as he wanted in excel and sent it to him. But he is not able to edit the excel sheet, everytime he tries to select some measure or column from right hand side , he gets a prompt to connect to microsoft account and when he logs in it says cannot connect and operation failed.

I have tried to update the ananlyze excel updates on his system and installed the latest OLE DB Provider too, but nothing seems to be working out. He needs the excel to be editable so that he can slice and dice on the measures.

Can somebody help me please?

Regards,

Shweta

Re: Need Help- Analyse in excel issue

xpherion — Wed, 30 Aug 2017 19:58:03 GMT

Analyze is excel only works when it connects to Power BI Service (cloud) report. Here is the link for analyze in excel. You are connecting to a data source in Power BI service (cloud), it is always going to ask the user to login to Power BI cloud service.

Re: Need Help- Analyse in excel issue

shwets47 — Wed, 30 Aug 2017 20:25:32 GMT

Hi xpherion,

Thanks for the e-mail. but I alerady tried as mentioned in the post and it dint work. But i got the solution. I googled and someone had posted the same issue and i installed the ODBC drivers as instructed there. Sorry to say I am not able to find that link again. but that helped me resolve my issue.

Regards,

Shweta