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: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
calsavara
Frequent Visitor
‎11-05-2019 06:20 AM

Same issue here. It works fine on Service, and the error comes up on Desktop.

fchen83
Microsoft Employee
Microsoft Employee
‎11-06-2019 05:48 AM

I uninstalled and reinstalled Power BI desktop x64 version and in solved my issue.

calsavara
Frequent Visitor
‎11-06-2019 10:52 AM

Hi @fchen83 . Did you install it via Microsoft Store or the PBI website?

karaoan
Kudo Kingpin
Kudo Kingpin
‎11-11-2019 11:23 PM

Same problem here with latest November 19 update.

eddysteurs
Regular Visitor
‎11-12-2019 03:01 AM

same problem here , multiple pc's with new update of BI desktop to Nov version, reverted back to Sep version and it works again

karaoan
Kudo Kingpin
Kudo Kingpin
‎11-12-2019 09:44 PM

Had session with MS support: they confirmed it's a bug in November version of Power BI Desktop and the only way is to revert to October release.

 

Martin

 

Planning & Data Model Automation with Power BI -> https://www.acterys.com

laf
Regular Visitor
‎11-13-2019 12:09 AM

I experience the same issue. Problem is that I have installed Power BI Desktop from the Microsoft Store, and cannot find any way to downgrade it. Also I cannot find any installations files on the net for any previous versions. Any idea of how to solve this?

eddysteurs
Regular Visitor
‎11-13-2019 01:20 AM

Laf

 

you can download it via the normal website (this is link for september version, but others are there too)

 
make sure you set automatic update of apps in MS store to off, or it might update it again.
 
 
laf
Regular Visitor
‎11-13-2019 01:48 AM

Thanks @eddysteurs. I have now downgraded and direct queries work again.

Anonymous
Not applicable
‎11-14-2019 11:50 AM

Same issue here. Works in the October release, but not the newest November release. 

Idea Statuses