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: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Daryl-Lynch-Bzy

Dataflow Refresh Error - Missing Client Library ADO.NET

Submitted by Community Champion on ‎05-04-2021 02:16 AM

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
See more ideas labeled with:
5 Comments (5 New)
Comments
Daryl-Lynch-Bzy
Community Champion
Community Champion
‎05-04-2021 02:37 AM

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
Community Champion
Community Champion
‎05-04-2021 02:43 AM

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
Community Champion
Community Champion
‎05-04-2021 03:08 AM

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
Community Support
‎05-04-2021 07:31 PM

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
Helper IV
‎12-30-2021 07:04 AM

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.

Idea Statuses