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
zrichardson's avatar
zrichardson
Icon for Advocate III rankAdvocate III
9 years ago

From what I am gathering, I can't have both.

 

If I want updated data every hour, I have to connect to excel through the service. 

 

If I want measures and columns, I need to connect to the power bi report through the service. 

 

Is there any way I can have both?

 

Thanks!

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi zrichardson,

In your sceanrio, it is not possible to sync changes from Power BI Desktop file and Excel file with OneDrive Hourly Refresh at the same time,but you can also set "Schedule Refresh" for your dataset expect OneDrive Refresh.

Thanks,
Lydia Zhang