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 

Once you created the dataflow, you need to refresh once then only it will have the data. refresh the dataflow and check in desktop.

Thanks

Hari

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


alam_p's avatar
alam_p
Frequent Visitor
4 years ago

Hi Hariharan_R ,

I patched the script and it worked. What i was not doing was to refresh. I think sometime we miss small step. Thanks for the response.