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'm looking for some information regarding auto refresh with Import Mode models in PowerBI Desktop and PowerBI Service. What is required for the auto refresh of an import mode model that is based on a SQL Server Database View?
For the past week or so I've been playing around with Scheduled Refresh, and have been able to refresh my Direct Query datasets with no issues, but I can't seem to figure out Import Mode refreshing.
I have however been unsuccessful in carrying out a scheduled refresh on an Import Model based off the same SQL Server View.
Any resources, information or videos etc would be highly recommended as I would like to be able to schedule refreshes in the future.
Thanks very much,
Ross
Solved! Go to Solution.
Hi @Anonymous ,
The import mode only supports Scheduled Refresh and manually refresh, if you want to refresh automatically, we can use the direct query.
Best Regards,
Teige
Hi @Anonymous ,
The import mode only supports Scheduled Refresh and manually refresh, if you want to refresh automatically, we can use the direct query.
Best Regards,
Teige
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.