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: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

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