Power Apps custom visual to the report

[koorosh]

Hello Experts,

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: You add a Power Apps custom visual to the report.

Does this meet the goal?

A.Yes

B.No

What is the correct answer of the above question and why, please ?

[Anonymous]

Hi @koorosh ,

According to your statement, I think your question is to know how to use parameter with data source location in your Query. I think you can replace the location by parameter in Advacned Editor.

For reference: https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

Best Regards,
Rico Zhou

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