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.
Is it possible to have a scheduled cache refresh with a DirectQuery dataset without having a Gateway?
Solved! Go to Solution.
There is no need to configure the refresh for the online source, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization. For more information, please refer to https://docs.microsoft.com/en-us/power-bi/refresh-data#onedrive-refresh
Hi @Anonymous ,
If it is an on-premise data source, we should use gateway. Otherwise, PowerBI Service cannot access the data source, if it is an online source, there is no need to use a gateway.
Best Regards,
Teige
How would I schedule the refresh if its an online resource using directQuery. On power Bi service, the schedule refresh option for the dataset is grayed out.
There is no need to configure the refresh for the online source, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization. For more information, please refer to https://docs.microsoft.com/en-us/power-bi/refresh-data#onedrive-refresh
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.