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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi zrichardson，

In your sceanrio, when you add new measures, change column names, or edit visualizations in Power BI Desktop file, once you save, those changes will be updated in Power BI , usually within about an hour. When you make changes in the Excel file, you can only manually refresh the dataset by using Refresh now or set up a refresh schedule by using Schedule Refresh. For more details, please review this article.

However, if you want to make Onedrive hourly refresh work after making changes to Excel file, please directly connect to the Excel file located at Onedrive for Business from Power BI Service rather than from Power BI Desktop.

Thanks,
Lydia Zhang

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

So you are telling me that if I want to have any measures, calculated columns, or custom visuals, I wouldn't be able to use the onedrive hourly refresh?

 

Thanks!