Direct Query

[pstanek]

Hi I currently use direct query and it showed me this problem

Problem is that I haven´t imported  nothing. It appears during opening bi file .Do you have idea how I can fix it?

[v-qiuyu-msft]

Hi @pstanek,

From the message when you refresh, it seems that you use DirectQuery connection, while there have some steps require Import mode.

1. Before install the April desktop version, is the report can be refreshed successfully in desktop.

2. Is the .pbix changed after update the desktop version.

3. Open the Query Editor and check which steps used in the query cause the issue. You can open the Advanced Editor for each query and copy to save the Power Query in NotePad. Then go to Applied Steps, delete each step then apply the change to see if the error throws out. 

Best Regards,
Qiuyun Yu

[pstanek]

thanks it worked

[v-qiuyu-msft]

Hi @pstanek,

As the issue is gone, would you please share the solution which can benefit other communities who has the same issue? Also please mark a helpful reply as an answer so that we can close the thread.

Best Regards,
Qiuyun Yu

[pstanek]

It also says .

[pstanek]

I t appears that it takes one my data source as more sources. but how It can be. I have no idea

[pstanek]

Funny thing is when I publish it to online version. Online version works

When I open pbix in desktop and use continue instead of validate , my report will appear , but It shows same error, when I use refresh.

[pstanek]

Hi Problem appeared, after installation april updates in desktop.

Can I find all sources .that I use in report, problem is I have no idea where the problem is, so I have no idea how to solve it.