Forum Discussion
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...
Yes, from what I have gathered, to get an hourly refresh of your OneDrive Excel data, you would have to be directly connected to it through the service. If you connect to the Power BI Desktop report, it will not be updated through the Power BI Hourly Update. If you make any changes to the Desktop Report, those will be picked up on the Hourly Update.
Then this is arbitrary close to being useless. We need to author reports in Desktop, and we need updated data.
That was my thoughts exactly. If you didn't need calculated columns or measures, you could connect the Power BI Service straight to your excel sheet and have hourly updates, but as soon as you want to make any more complex report or use custom visuals, that plan goes out the window.