Forum Discussion

lo_p_ez's avatar
lo_p_ez
Icon for Advocate II rankAdvocate II
9 years ago

Can't refresh OLAP Cube generated by PowerBI through "Analyze in Excel"

I have a dashboard in PowerBI that gets refreshed every day through our Data Gateway. I also have an Excel pointing to that dashboard. I'd like this Excel to be already refreshed when I open the Exce...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

lo_p_ez

 

Can you be more specific on how to have an Excel pointing to the dashboard?
By the way, you question seems more an Excel developement one, maybe more better support from the dedeciated forum.

  • lo_p_ez's avatar
    lo_p_ez
    Icon for Advocate II rankAdvocate II
    9 years ago

    By pointing to, I mean through the PowerBI addin. This addin makes a connection to a dashboard in PowerBI. In the background Excel creates a connection that the user can refresh manually, I want to aumate this piece.

    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      lo_p_ez

       

      When pinning tables onto dashboard via Power BI Add-in in Excel, it actually just upload the snapshot of the table (which is image) onto dashboard.

       

      The Refresh in "Pin Manager" will just re-upload an new image. It's not dataset, we can't do schedule refresh on Power BI. And within this add-in, currently there's no automation option supported. See: Power BI publisher for Excel.

       

      So for your requirement, you should upload Excel workbook onto Power BI Service to generate a dataset. Then you can schedule refresh with Gateway. See: Refresh a dataset created from an Excel workbook on a local drive.

       

      Regards,