Forum Discussion

zrichardson's avatar
zrichardson
Icon for Advocate III rankAdvocate III
9 years ago

OneDrive Excel to OneDrive pbix to Power BI Service

This is my setup:   I have an excel document that is updated on OneDrive Hourly. I have a pbix file that is connected to that excel document that is uploaded to my OneDrive. Finally, I have the Pow...
Need Help
alanhodgson's avatar
alanhodgson
Icon for Solution Supplier rankSolution Supplier
9 years ago

Hey zrichardson,

 

It sounds like you want the data in the Excel file to refresh when the hourly OneDrive refresh happens. I am assuming you are using the "Import" method to create your data model.

 

Here is the limitation:

   - If the Excel sheet has any external connections to a database or another workbook, then you must manually go into the Excel sheet and "Refresh All", before the changes will show in PBI Service.

 

Also, have you configured an on-prem data gateway? If so, personal or enterprise?

 

Hope this helps,

 

Alan