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.
Hello
I am rather new to power BI. I have 2 data source. 1 is an excel spreadsheet and the other is Dynamics Online. I am unable to create any scheduled refresh.
Any help is greatly appreciated.
Frank
Solved! Go to Solution.
Hi @Anonymous ,
There are several scenarios you may considerate:
1.If your excel file is saved on premise, then it needs to use the gateway and 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.
2..If your excel file is saved on line, such as SharePoint online, OneDrive for business and so on, that is to say the dataset only has the cloud data sources , then it needn't to use the gateway. You can manually refresh the dataset by using Refresh now or you can set up a refresh schedule by using Schedule Refresh. Power BI automatically connects to the on line data sources . If the data has changed, Power BI will refresh the dataset and reports in the Power BI service.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hi @Anonymous ,
There are several scenarios you may considerate:
1.If your excel file is saved on premise, then it needs to use the gateway and 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.
2..If your excel file is saved on line, such as SharePoint online, OneDrive for business and so on, that is to say the dataset only has the cloud data sources , then it needn't to use the gateway. You can manually refresh the dataset by using Refresh now or you can set up a refresh schedule by using Schedule Refresh. Power BI automatically connects to the on line data sources . If the data has changed, Power BI will refresh the dataset and reports in the Power BI service.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.