cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shwets47
Frequent Visitor

Need Help- Analyse in excel issue

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

1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2
xpherion
Advocate II
Advocate II

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.

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

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.