March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi guys,
I have PBIX file that has a bunch of queries to an Azure SQL server. All of these queries are import.
At some point, I tried to add a Direct Query on PBI Desktop (after turning on the Preview Feature).
It wasn't great because of the constraint to make many-to-many relationships with Import queries so I removed that only Direct Query.
Now when I publish this PBIX file to the PBI service, I can't schedule the refresh anymore, it treats it as a DirectQuery only file.
The data set has this warning displayed:
This dataset connects to a source with DirectQuery, which is always up-to-date. You don't have to schedule a refresh on this dataset.
But I actually don't... All the queries are import. Is there any way to trick the service into importing the data again?
Solved! Go to Solution.
Hi Ross,
Thanks for your reply.
I've found a solution: in the options, de-activate Composite Queries in the options, add a table with Enter Data, delete it, save and re-publish and it works!
Based on this article:
https://docs.microsoft.com/en-au/power-bi/desktop-composite-models
Once you make it a composite model, schedule refresh should treat it like an import model, not the other way around.
My first step would be to try getting the latest version of the Power BI desktop and publish again. Also check the 'Data Source Settings' under the EDIT Queries menu to see if anything stands out to you.
Hi Ross,
Thanks for your reply.
I've found a solution: in the options, de-activate Composite Queries in the options, add a table with Enter Data, delete it, save and re-publish and it works!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
37 | |
22 | |
20 | |
10 | |
9 |
User | Count |
---|---|
60 | |
56 | |
22 | |
14 | |
12 |