Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Direct Query Issues

Submitted by Anonymous on ‎11-12-2019 10:49 AM

I have a couple of reports that are using Direct Query to Azure SQL DB. When i was trying to make a change to the report and trying to publish the file, data didn't load to PowerBI Desktop. 

It kept on giving me the following error image.png

 

 
Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎11-12-2019 10:52 AM

Just FYI, the same query works in Import Mode

v-qiuyu-msft
Community Support
Community Support
‎11-12-2019 11:37 PM

Hi @Anonymous, 

 

Which kind of the changes did you made to the report? If you only didn't do any changes in Query Editor, I would suggest you open the report which uses import mode, make the same changes, click on Refresh button to see if there is any issue occurs. 

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable
‎11-13-2019 05:31 AM

Hi Qiuyun,

 

The report originally was using Direct Query mode, i just made some changes to the logic of the SQL, basically commented out a where condition. As it turned, all the other reports were also giving the same error.

I just tried using the same SQL in Import to see if it works, turned out it did.

 

So, there's an issue with the Direct Query.

Idea Statuses