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 command, it never works properly.  It will not open the dataset in the Excel desktop. I always get prompted by the following failure message:

 

But if I repeat the "analyze in excel" a second time, then the next time it works correctly.  I am then able to proceed to interact with the data in an Excel pivot table on the desktop.

 

It would avoid a lot of frustration if I didn't have to repeat my request twice, each time I want to explore an unfamiliar dataset.  Can someone please tell me how to get the proper behavior the first time use this command? 

 

Any help would be appreciated.

 

Need Help

5 Replies

  • 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.