Forum Discussion

dbeavon3's avatar
dbeavon3
Memorable Member
3 years ago

Analyze in Excel (for a Dataset)

I'm struggling with the "analyze in excel" command for a dataset.  I use this frequently to explore our datasets using pivot tables in the Excel desktop.   For some reason the first time I use the ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi dbeavon3 ,

Below picture message is not the error message, this is an indication that you have completed this operation.

When you click "Analyze in Excel" button in Power BI Service,The Power BI service generates an Excel workbook that contains an OLAP connection to the Power BI dataset, and automatically saves this Excel workbook to your OneDrive for Business. You can now open the Excel workbook by clicking Open in Excel for the web and the workbook opens in a new browser tab. 

But If you don't have OneDrive for Business in your environment, clicking Analyze in Excel will download the Excel workbook to your computer's local Downloads folder.

 

For more details, you can read related document: Start in Power BI with Analyze in Excel - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dbeavon3's avatar
dbeavon3
Memorable Member
3 years ago

Hi Anonymous 

Thanks for the information.  I really appreciate your time.

 

That message is an error as far as I'm concerned, since it says it won't open my data on the desktop. 

 

Can you tell me how I can make it work correctly the first time?  It needs to download and open on the desktop.  It is a bit silly that I have to issue the "analyze in excel" a second time before it does what I need.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi dbeavon3 ,

    So far, this is the case for using this feature.

    If you have a good suggestion, you can make it here Ideas (powerbi.com).

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • dbeavon3's avatar
      dbeavon3
      Memorable Member
      3 years ago

      Anonymous 

      Hi, thanks for the reply.
      You mentioned that it works the way it does because of my "OneDrive for Business."  Is there any way to trick Power BI into thinking that I don't have OneDrive for Business?  That is something that I don't use and didn't know I had.

      • dbeavon3's avatar
        dbeavon3
        Memorable Member
        3 years ago

        Anonymous 

        Hi, thanks for the reply.

         

        If I can disable onedrive for business altogether, I would even go that far to fix this issue.