Forum Discussion
Refreshing Google Analytics and OneDrive CSV data
Hi Anonymous,
1. How did you get the file on OneDrive? If you just use the Excel connector and the path of the OneDrive local folder, that won't work. Because Power BI doesn't know if it's on OneDrive.
2. I would suggest you refer to power-bi/desktop-use-onedrive-business-links and create a report. Then set scheduled refresh.
3. If you'd like the one hour refresh on OneDrive, please refer to refresh-csv-file-onedrive. The CSV file is actually imported in the Power BI Service.
Best Regards,
Dale
I tested loaded bothing of my inputs into seperate .pbix files to see which source is causing the problem:
1. the Google Analytics data source allowed me to reschedule a refresh
2. the CSV data on my OneDrive still did not update within an hour of my changes in my desktop or online and the refresh option online is still greyed out.
This leads me to 2 possible conclusions:
1. having both data sources restricts me from creating a refresh schedule
2. somehow the CSV on my OneDrive synching is messed up still (the .pbix file is also located on my OneDrive)
Any guidance would be helpful!
Hi Anonymous,
1. How did you get the file on OneDrive? If you just use the Excel connector and the path of the OneDrive local folder, that won't work. Because Power BI doesn't know if it's on OneDrive.
2. I would suggest you refer to power-bi/desktop-use-onedrive-business-links and create a report. Then set scheduled refresh.
3. If you'd like the one hour refresh on OneDrive, please refer to refresh-csv-file-onedrive. The CSV file is actually imported in the Power BI Service.
Best Regards,
Dale