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...
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.