Dynamic Query from Dataflow as a Source

[Anonymous]

Hello. I really hope someone can help me.

Does anyone know if it is possible to use M Dynamic Query using Power BI Dataflow as a source? I have seen examples using SQL and Azure as sources like in the pictures below.

In the image above, the parameters are being referenced in the Source line of code. The parameters are created in Desktop and referenced in M code like in the image above, but how can I do this if when I import data from a dataflow, I have this line of code?

Really hope someone knows where can I reference the parameter in this case.

For information, my two first lines of code in the Power Query when I am creating a dataflow is the following:

let

  selectedCountry = Text.From(CountryParameter),

  Source = Xml.Tables(Web.Contents("https://emm.newsbrief.eu" , [RelativePath="rss/rss?type=category&id="&selectedCountry&"]))

So, how can I referenced the CountryParameter in Desktop if when I importa the dataset, it is like that:

Thank you.

Kind regards

[Anonymous]

Hi @Anonymous ,

There's a connector you can connect directly, why not give it a try?

Reference: Configure and consume a dataflow - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous 

Thank you so much for replying! I was loosing hope. I was definitely not clear on my question. So, I used the dataflow connector you showed in your message. 

I am struggling in creating Dynamic M Query Parameters, where I can let report viewers to use filters or slicers to set the value of countries. 

After I connect the dataset using the dataflow connector in Power BI Desktop, this line of code appears to me in Power Query:

let

Source = PowerPlatform.Dataflows(null),
Workspaces = Source{[Id="Workspaces"]}[Data]

I searched everwhere and I cannot find a way to reference a parameter on that. Do you know a way of doing it?

Thank you for your attention.

Kind regards,

Lucianna

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may check this:

Power Query (M)agic: Parameters for Dataflows!

And the link below is included in the article above and maybe a better solution.

Pimp the dataflows connector in Power BI

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you @Anonymous !

That helps.

Kind regards,

Lucianna