Forum Discussion

zrichardson's avatar
zrichardson
Advocate 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
Solution 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

 

 

 

zrichardson's avatar
zrichardson
Advocate III
9 years ago

I am not using "Import" because I am not connecting the service directly to the excel file. I am connecting the service to the pbix file on OneDrive. I am connecting the pbix file to the excel file on OneDrive. 

 

I am not using any external data sources in my excel file. I have a scheduler that sends me an updated csv in an email. I use Microsoft flow to save over the previous file. That is how I update the data. 

 

Again, everything updates perfectly when I go and manually "Refresh Now" the data source. However, the data does not refresh on the hourly OneDrive updates.

 

Thanks!