Forum Discussion

alam_p's avatar
alam_p
Frequent Visitor
4 years ago
Solved

Change power bi desktop table source to dataflow tables.

Hi All,    It might have been answered but just want soution for this.  Is it possible to change the data source of the table in power bi desktop with the same table source in my dataflow. Both ...
Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi alam_p 

    You can change but you need to perform in your dataflows. Attached the sample which is taking dataflow table in Power BI desktop.

     

     

    let
    Source = PowerPlatform.Dataflows(null),
    Workspaces = Source{[Id="Workspaces"]}[Data],
    #"c7e60087-de7d-47ee-9058-870561595b39" = Workspaces{[workspaceId="c7e60087-de7d-47ee-9058-870561595b39"]}[Data],
    #"80ac8046-1118-4c63-b159-0af633321a2f" = #"c7e60087-de7d-47ee-9058-870561595b39"{[dataflowId="80ac8046-1118-4c63-b159-0af633321a2f"]}[Data],
    accounts_ = #"80ac8046-1118-4c63-b159-0af633321a2f"{[entity="accounts",version=""]}[Data]
in
    accounts_

     

     

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin


Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
4 years ago

Hi alam_p 

You can change but you need to perform in your dataflows. Attached the sample which is taking dataflow table in Power BI desktop.

 

 

let
    Source = PowerPlatform.Dataflows(null),
    Workspaces = Source{[Id="Workspaces"]}[Data],
    #"c7e60087-de7d-47ee-9058-870561595b39" = Workspaces{[workspaceId="c7e60087-de7d-47ee-9058-870561595b39"]}[Data],
    #"80ac8046-1118-4c63-b159-0af633321a2f" = #"c7e60087-de7d-47ee-9058-870561595b39"{[dataflowId="80ac8046-1118-4c63-b159-0af633321a2f"]}[Data],
    accounts_ = #"80ac8046-1118-4c63-b159-0af633321a2f"{[entity="accounts",version=""]}[Data]
in
    accounts_

 

 

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin