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: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

fchen83

Direct Query issues

Submitted by Microsoft Employee on ‎11-04-2019 03:38 PM

I currently have a couple of reports that use DirectQuery to an Azure SQL database.

This morning I have been getting this error message whenever I try to open / refresh the report:

Keyword not supported: 'global pipe'.. The exception was raised by the IDbConnection interface.

 

The only change that have been done recently on my machine is the recent windows update.

 

 

 

Status: New
See more ideas labeled with:
23 Comments (23 New)
Comments
RayNg
Frequent Visitor
‎11-14-2019 01:51 PM

Ditto, ditto, ditto! Thank you @eddysteurs for providing the link and suggestion to swtich off the auto update!

mothman
Frequent Visitor
‎11-14-2019 05:51 PM

Same thing happening for us here, with the November version (both store and non-store). Completely can't use any reports using DirectQuery to Azure SQL. Seems like a huge bug!

FrankPreusker
Advocate III
Advocate III
‎11-15-2019 01:04 AM

I initially thought, that my local pbix file is broken, but the issue is happening as well on a fresh copy of the same file from PBI Service. Can somebody from Microsoft please post a resolution date here?

Anonymous
Not applicable
‎11-18-2019 12:46 PM

It happens to me as well. Don't know how to downgrade to Oct. Help! This is a serious issue. 

RayNg
Frequent Visitor
‎11-18-2019 01:53 PM

Hello @Anonymous , I had the same issue too. Read @eddysteurs earlier post. He provides a url to the October version of PowerBI; just uninstall your current version and install that older version to resolve this.

 

Anonymous
Not applicable
‎11-19-2019 06:42 AM

is there any eta on a fix?  I don't have the access to uninstall the store app and IT won't roll back 😞

karaoan
Kudo Kingpin
Kudo Kingpin
‎11-20-2019 03:14 PM

Just FYI: The new .801 PBI Desktop version published today (20/11/19) unfortunately doesn't fix the problem.

karaoan
Kudo Kingpin
Kudo Kingpin
‎11-24-2019 06:11 PM

Version .861 finally fixes the issue...

Anonymous
Not applicable
‎11-25-2019 01:46 AM

Thanks for the update!

Anonymous
Not applicable
‎12-04-2019 12:37 PM

Ditto, I had the same issue. As I am relatively new to PowerBI I thought there was a problem with the local pbix file that my colleague had created. Thankfully not. Seems like a huge bug. 

Idea Statuses