Direct Query Issues

[mudgilam]

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 

[mudgilam]

Just FYI, the same query works in Import Mode

[v-qiuyu-msft]

Hi @mudgilam, 

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

[mudgilam]

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.