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

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.