Forum Discussion
Gateway not connecting to excel files
Community ChampionEvanBeiser do you absolutely need power bi desktop to connect to downloaded onedrive files and refresh it that way ? I would suggest if you're not using power bi desktop to do data transformations heavily (and if needed you are able to do that at the source level) then skip the steps of downloaded one drive excel files locally -> power bi desktop -> gateway. You can connect to onedrive personal or business straight from power bi service and build your reports and dashboards there. Data will also be refreshed automatically per hour.
You can click on Get Data -> Files in power bi service and connect to onedrive files. There is a small workaround you need to do before you can use excel file in power bi and refer to this article to get that done.
To me this would be the simplest approach as you'r taking away layers of local excel files -> pbi desktop and gateway.
Advocate II am having the exact same issue. I am doing heavy data transformations. How do you get around this? My data updates throughout the day. I want a schedule to update every hour. Is this not possible today?