Calling Power BI reports from ADF

Hi @Bodke, Anil
Welcome to Microsoft Q&A platform and thanks for posting your question here.

To create dynamic dataset connections in Power BI that can change based on the client information passed from an Azure Data Factory pipeline, you can use the parameters defined in the ADF pipeline within your Power BI dataset connection strings. This means that you can create connection strings that are specific to each client and can change dynamically based on the client information passed from the ADF pipeline.

Here’s how you can structure your dataset connection strings using the parameters from the ADF pipeline:

For FileA:
https://lstest.dfs.core.windows.net/@{variables('Customer')}/prepay-claim-daily/@{pipeline().parameters('batchFileIdentifier')}/validated/common/fail/FileA

For FileB:
https://lstest.dfs.core.windows.net/@{variables('Customer')}/prepay-claim-daily/@{pipeline().parameters('batchFileIdentifier')}/validated/common/fail/FileB

... and so on for FileC, FileD, FileE, FileF

By following this structure, when the ADF pipeline is triggered for a particular client, the Power BI report will dynamically connect to the correct dataset based on the client information provided by the ADF pipeline.

I hope this information helps you. Let me know if you have any further questions or concerns.