cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Direct Query

Hi I currently use direct query and it showed me this problemCapture.PNG

 

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

7 REPLIES 7
Highlighted
Post Patron
Post Patron

Re: Direct Query

It also says .

Capture.PNG

Highlighted
Post Patron
Post Patron

Re: Direct Query

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

Highlighted
Post Patron
Post Patron

Re: Direct Query

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.

Highlighted
Post Patron
Post Patron

Re: Direct Query

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.

Highlighted
Community Support
Community Support

Re: Direct Query

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Patron
Post Patron

Re: Direct Query

thanks it worked

Highlighted
Community Support
Community Support

Re: Direct Query

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors