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
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,