Error on Directquery

[Anonymous]

Hello,

I am using Directquery, connected to a SQL Server Database.

I am getting the following errors:

"Model schema could not be loaded"

hit close, next errors showing up: "Not allowed to combine Directquery and Import function"

However, I am only using Directquery!

There are also some more bugs, such as when i add another table from exactly the same server and database, it tells me I am not allowed to use two different sources.

Please urgently spend some time investigating on the functionality of the Direct Query, I am really struggling to get things running.

[v-qiuyu-msft]

Hi @Anonymous,

Based on my test, DirectQuery supports all tables from a single database. In your scenario, when you get data from SQL first time, is it a table, stored procedure or view? After you get data, do you perform any steps in Query Editor?

Which kind of desktop version did you run? Can you try to update to the latest version.

Best Regards,
QiuyunYu

[Anonymous]

Hi @v-qiuyu-msft

I'm connected to views in the SQL Database. I do not perform any steps in the Query Editor.

I am running the latest version of Power BI Desktop.

Best,

Chris

[prateekraina]

Hi @Anonymous,

As per my experience, this error occurs in following scenarios:

1. If you are trying to get data from multiple databases/servers while using Direct Query.
2. If your source database no longer exists.
3. If you have used a step in Power Query which is not supported in Direct Query mode.

I would recommend you to double check if you are actually getting data from a single database.
Also check the server in case you are using parameters for server and database names, you might be using parameter at one place and hard coded name at the other.

Prateek Raina