Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All, I have created a dashboard in powerbi and datasources are excel/csv files which are stored in one drive. Can you please suggest if it is possible to use On-premises data gateway (personal mode) to extract data from files saved in one drive. I want may dasboard to automcatically refresh data from one drive file. I will schdule the refresh it is possible. Any suggestion is welcome. Thanks
Proud to be a Super User!
Solved! Go to Solution.
Hi @negi007 ,
Recommend you upload the files to OneDrive for Business instead of a personal OneDrive, or upload to SharePoint Onlie. In this way, if your dataset contains only the files saved in OneDrive for Business, it needn't to use gateway and it is not possible to configure the schedule refresh interval. You can only deactivate OneDrive refresh in the dataset's settings. OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI refresh every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization. See more: https://docs.microsoft.com/en-us/power-bi/refresh-data#onedrive-refresh .
While if your dataset not only contains cloud data source OneDrive for Business but also other on premise data sources, then it needs to use the gateway , also the data source OneDrive for Business should be add to the gateway as other on premise data source, as described in Add a data source, and then you can configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @negi007 ,
Recommend you upload the files to OneDrive for Business instead of a personal OneDrive, or upload to SharePoint Onlie. In this way, if your dataset contains only the files saved in OneDrive for Business, it needn't to use gateway and it is not possible to configure the schedule refresh interval. You can only deactivate OneDrive refresh in the dataset's settings. OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI refresh every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization. See more: https://docs.microsoft.com/en-us/power-bi/refresh-data#onedrive-refresh .
While if your dataset not only contains cloud data source OneDrive for Business but also other on premise data sources, then it needs to use the gateway , also the data source OneDrive for Business should be add to the gateway as other on premise data source, as described in Add a data source, and then you can configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@negi007 , In the case of one drive and SharePoint. On power bi service schedule a refresh. It will ask for credentials and provide that and schedule
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
Also refer
https://www.youtube.com/watch?v=qu6O2ySCeOA
@negi007
Please refer o these articles:
https://www.youtube.com/watch?v=I0KVU9iRMCA
https://www.youtube.com/watch?v=uxMlV9KKf6E
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |