cancel
Showing results for 
Search instead for 
Did you mean: 

New Power Platform Dataflow Connector not working

I've seen two reports. Here is one - Re: New DataFlow conector not working - Microsoft Power BI Community

edhans_0-1631201850845.png

@JORGE_MOLTENI - track the issue here. Hopfully it is resolved fast.

 

Status: Delivered
Comments
mllopis
Microsoft

This is Miguel from the Power Query & Dataflows team at Microsoft - Wanted to acknowledge this thread and confirm that we're investigating the issue and will try to resolve as quickly as feasible.

 

Apologies for the inconvenience. Please stay tuned to this thread for updates on resolution.

 

Thanks,
M.

JORGE_MOLTENI
Frequent Visitor

Thanks @mllopis !

mllopis
Microsoft

Wanted to provide an end of the day update on this issue:

 

  • We have identified the root cause of the issue.
  • We have a fix for this issue being deployed.
  • We expect the fix to be deployed by EOD Friday (PST).

We’ll share another update tomorrow.

v-yingjl
Community Support

Internal ICM which has been submited: 260733741

 

Best Regards,
Community Support Team _ Yingjie Li

JORGE_MOLTENI
Frequent Visitor

Hi @mllopis and @edhans is working now! thanks 👻

olopuc
Frequent Visitor

Just an FYI, since the solution might not be until EOD today. If you need to do development work on a Power BI report that uses Power BI Dataflows,  you can switch the connector back to the old dataflow connector.  The steps are fairly similar and only need minor tweaking. 

Old Connector Query Steps:

let
Source = PowerBI.Dataflows(null),
#"b17......" = Source{[workspaceId="b17......"]}[Data],
#"370......" = #"b17......"{[dataflowId="370......"]}[Data],
EntityName = #"370......"{[entity="EntityName"]}[Data]
in
EntityName


New Connector
let
Source = PowerPlatform.Dataflows(null),
Workspaces = Source{[Id="Workspaces"]}[Data],
#"b17......" = Workspaces{[workspaceId="b17......"]}[Data],
#"370......" = #"b17......"{[dataflowId="370......"]}[Data],
EntityName_ = #"370......"{[entity="EntityName",version=""]}[Data]
in
EntityName_

FYI. This would work even better if Power Query used generic identifies for the steps in this process instead of assigning the GUid as the step name. I do this manually to make code reusable.

So for the New Connector it would read:

let
Source = PowerPlatform.Dataflows(null),
Workspaces = Source{[Id="Workspaces"]}[Data],
Workspace = Workspaces{[workspaceId="b17..."]}[Data],
Dataflow= Workspace{[dataflowId="370..."]}[Data],
Entity = Dataflow{[entity="EntityName",version=""]}[Data]
in
Entity


mllopis
Microsoft

Final update: Connector fix has been deployed to most regions (with others finishing later today) and you should be able to see it and use it in Power BI Desktop now, after restarting Power BI Desktop.

v-yingjl
Community Support
Status changed to: Delivered