Change power bi desktop table source to dataflow tables.

[alam_p]

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 the table is from business central and now i want to use dataflow instead of datasets. 

How could it be done in advance editor. 

Thanks.

[alam_p]

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]

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]

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.

[Hariharan_R · Accepted solution]

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