Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Can't schedule refresh on a dataset that doesn't contain a DirectQuery (but used to)

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?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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!

 

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

Anonymous
Not applicable

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!

 

 

 

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors