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


alam_p's avatar
alam_p
Frequent Visitor
4 years ago

Thanks Hariharan_R, Thanks for you respone. Yes, this is in the dataflow. 


I have already published a report with a sales tables dataset. Now i have created the dataflow with same sales tables and want to change the dataset to this new dataflow. (Tables are same everywhere)

I am pasting this dataflow in the advance editor of power bi desktop but it is giving me blank when run the query.


Just the patching of coded is not workin or am i doing somthing wrong.

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.