Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Dataflow Refresh Error - Missing Client Library ADO.NET

I am attempting to refresh Dataflow hosted on Gen2 Prem.  The Dataflow is linking to another Dataflow.  This is the error message:  

 

DataSource.MissingClientLibrary: ADO.NET: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Details
DataSourceKind = PowerPlatformDataflows
DataSourcePath = PowerPlatformDataflows

I can use the same Dataflow from Power BI Desktop.
Status: New
Comments
Daryl-Lynch-Bzy
Resident Rockstar

One possible cause of this issue is that the M query is different depending on when and how the Dataflow is created.  Has something changed in the Power BI Dataflow connector.

M Query from Failing Dataflow - This works in Power BI Desktop.
let
  Source = PowerPlatform.Dataflows(null),
  Navigation = Source{[Id = "Workspaces"]}[Data],
  #"Navigation 1" = Navigation{[workspaceId = "yyy"]}[Data],
  #"Navigation 2" = #"Navigation 1"{[dataflowId = "zzz"]}[Data],
  #"Navigation 3" = #"Navigation 2"{[entity = "abc"]}[Data]
in
  #"Navigation 3"



M Query from new Query in Power BI Desktop
let
Source = PowerBI.Dataflows(null),
Navigation = Source{[workspaceId="yyy"]}[Data],
#"Navigation 2" = Navigation{[dataflowId="zzz"]}[Data],
#"Navigation 3" = #"Navigation 2"{[entity="abc"]}[Data]
in
#"Navigation 3"

 

 

M Query from new Dataflow
let
  Source = PowerBI.Dataflows([IncludeGroups = false, SourceDataflowId = "xxx"]),
  Navigation = Source{[workspaceId = "yyy"]}[Data],
  #"Navigation 1" = Navigation{[dataflowId = "zzz"]}[Data],
  #"Navigation 2" = #"Navigation 1"{[entity = "abc"]}[Data]
in
  #"Navigation 2"

 

Daryl-Lynch-Bzy
Resident Rockstar

Another error message encountered while attempt to trouble-shoot is:

LocalStorage is being blocked. Please enable local storage and try signing in again. Depending on your browser, this may require enabling cookies or trackers for this site. (Session ID: f7afa5a4-1029-4418-a240-3fd585eaaf84)

I get this message occassionally when attempting to create a new linked dataflow from scratch.

Daryl-Lynch-Bzy
Resident Rockstar

Finally, when it seems like I have created a new Dataflow - the validation cycle is taking a very, very long time.

v-lili6-msft
Community Support

hi

there is a known issue:

Power BI customers using the Power Platform Dataflow connector for Dataflows may experience issues when creating new data flows or refreshing existing ones.

As a workaround, customers can use Power BI Dataflows connector instead of PowerPlatformDataflows connector

 

 

Regards,

Lin

009co
Helper IV

RE" "LocalStorage is being blocked. Please enable local storage and try signing in again. Depending on your browser, this may require enabling cookies or trackers for this site. (Session ID: f7afa5a4-1029-4418-a240-3fd585eaaf84)"

 

In my case it was because my browser settings were blocking pop-ups. this was resolved by allowing pop-ups in site settings for https://app.powerbi.com which required refreshing the page. Then the authentication pop-up can be shown and complete the process successfully.