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

[Anonymous]

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?

[Anonymous]

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 · Accepted 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!