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: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

nicg

DirectQuery Dataflows IDbConnection error

Submitted by Advocate II on ‎12-23-2020 10:44 AM

I have a dataflow published in the Power BI Service with the Enhanced Compute Engine turned on. When I add the dataflow to Power BI Desktop as an import, it works as expected. If I choose DirectQuery instead and click load, I get this:

 

Error.png

Status: New
See more ideas labeled with:
13 Comments (13 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎12-24-2020 01:09 AM

@nicg 

 

I cannot reproduce the issue. You may try the latest version of Power BI Desktop.

Anonymous
Not applicable
‎12-24-2020 05:57 AM

Same here : can not load a Dataflow with Enhanced Compute Engine On using Direct Query in Power BI Desktop

 

strawn_1-1608818177764.png

strawn_2-1608818190527.png

strawn_0-1608817995288.png

 

MBonnett
Advocate II
Advocate II
‎12-24-2020 07:41 AM

This worked for my team prior to the December Power BI Update and I think it is related to an issue that I am having with the new DirectQuery for Power BI datasets and Analysis Services functionality, too. 

 

image.png

 

My other issue, that I believe is related, can be found here:

https://community.powerbi.com/t5/Issues/DirectQuery-for-Power-BI-datasets-and-Analysis-Services/idc-... 

nicg
Advocate II
Advocate II
‎12-24-2020 08:07 AM

@v-chuncz-msft 

 

I am on the latest version. This worked fine in a previous version, though I'm not sure how many versions ago that was.

 

I tried switching the dataflow workspace from Gen1 to Gen2 as well as turning off and back on the Enhanced Compute Engine at the dataflow level, but it didn't help.

jeffshieldsdev
Solution Sage
Solution Sage
‎12-28-2020 06:34 AM

Same error for me...I just installed a new version of Power BI Desktop this morning

Version: 2.88.802.0 64-bit (December 2020)

This is at the top of the stack trace:

Microsoft.PowerBI.ReportingServicesHost.CannotRetrieveModelException: An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to get CSDL. ---> MsolapWrapper.MsolapWrapperException: Failure encountered while getting schema

   at MsolapWrapper.Utils.ThrowErrorIfHrFailed(Int32 hr, String message)

Kenyan
Regular Visitor
‎12-29-2020 04:26 AM

same issue for me

Kenyan
Regular Visitor
‎12-29-2020 04:30 AM

i believe this issue is related to december version, where can i download the previous version?

jeffshieldsdev
Solution Sage
Solution Sage
‎12-29-2020 06:37 AM

@Kenyan 

Previous versions of Power BI Desktop can be downloaded from here: https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive 

senzero
Regular Visitor
‎01-04-2021 11:00 AM

Hi.  I am experiencing the exact same issue with my Dataflow and Power BI December 2020 release.  Please help.

nicg
Advocate II
Advocate II
‎01-06-2021 08:34 AM

I rolled back to the November release and it works fine. So, it's definitely an issue with December.

Idea Statuses