This step results in a query that is not supported in DirectQuery mode

[StephenF]

I want my table datset to use directquery and autorefresh everyminute or so from the database using "page autorefresh" .

This imported sql server table however is refusing to cooperate.

Below is the initial source step - how to fix?

Once imported i do a few edit query operations on it to clean it up.

[v-luwang-msft]

Hi @StephenF ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[v-luwang-msft · Accepted solution]

Hi @StephenF ,

The term modeling in this context means the act of refining and enriching the raw data, as part of authoring a report using it. Examples include:

• Defining relationships between tables
• Adding new calculations (calculated columns and measures)
• Renaming and hiding columns and measures
• Defining hierarchies
• Defining the formatting, default summarization and sort order for a column
• Grouping or clustering values

To learn more details ,you could read the following article:

About using DirectQuery in Power BI:https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about 

Wish it is helpful for you!

Best Regards

Lucien

[aj1973]

Hi @StephenF 

Direct Query mode comes with some limitations

[StephenF]

Is there a list of these exact limitations? - need to know what i will have to move to the sql server and do there.

[aj1973]

@StephenF 

Unfortunately I don't.