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
Been testing Direct Query vs Import mode connection to On-Prem SQL, when it comes to Tiles refresh in Dashboard.
Are also using the REST API to publish updates to tiles in Dashboard. But API is excluded in this test.
I have installed the Enterprise gateway (preview) and tested Direct Query vs Import data against on-prem SQL.
This is what I got so far.
Import Datasets On-Premise SQL
Every time the dataset is updated in PowerBI, either manual or through Schedule refresh:
Direct Query dataset On-Premise SQL
When SQL DB On-prem is updated:
Anyone have any input on this or is this a pattern others allso see?
Thx for all inputs.
Hi @Knallert,
4 months after your post the situation is the same. Unfortunately.
Have you registered a support case on this?
I plan to do this now as this is really something that the end users are struggling with and are constantly complaining to me.
Best regards
Tsanka
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.