8 Comments

  • mllopis's avatar
    mllopis
    Icon for Community Admin rankCommunity Admin

    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.

  • mllopis's avatar
    mllopis
    Icon for Community Admin rankCommunity Admin

    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's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support

    Internal ICM which has been submited: 260733741

     

    Best Regards,
    Community Support Team _ Yingjie Li

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
    mllopis
    Icon for Community Admin rankCommunity Admin

    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.