cancel
Showing results for 
Search instead for 
Did you mean: 

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
Regular Visitor

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
Regular Visitor

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
Regular Visitor

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