New Power Platform Dataflow Connector not working

[edhans]

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

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

[mllopis]

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]

Thanks @mllopis !

[mllopis]

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]

Internal ICM which has been submited: 260733741

Best Regards,
Community Support Team _ Yingjie Li

[JORGE_MOLTENI]

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

[Anonymous]

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]

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.