Forum Discussion
Calling Power BI reports from ADF
Hi Anonymous
Apologies for the inconvenience, this community is specifically for discussions and questions related to Microsoft Fabric. For queries related to Azure Data Factory we recommend using the dedicated Microsoft Q&A forum where they are ready to assist you better. Here's the link to post your query in Microsoft Q&A : Ask a question - Microsoft Q&A.
Thanks.
Hello NandanHegde , thanks for your question.
So here is the complete explanation of my issue:
we have a data pipelines for different clients say client A, client B, client C, etc..
When we run the pipeline for Client A, that pipeline will create a folder (everytime) and it'll drop multiple files in that folder, same for other clients as well. What I need is once the files are droped in the folder, we need to call a power BI report and that should take these files path as connection string to the power BI report datasets.
So total 7 files will be created in the folder and I established 7 datasets (one for each file because files headers not same). when ever the pipeline got triggered and files got placed in the folder the next step should be passing those newly created files location as input to the Power BI dataset connection dynamically.
For now we done work till creation of folder and files. Now searching for possible ways to add the power bi to the pipelines.
Is it possible with ADF pipelines?
Thanks for you help in this.
Regards,
AB
- NandanHegde
Super User
So just to reiterate, you have X number of Power BI reports mapping to X number of diff files published.
So post data load, you need to update the connection string for those X datasets dynamically and refersh the dataset?
Is my understanding clear?
Also, can you show me what you mean by update the connection string here? Please provide the manual steps that you would do which would help us understand a way for automation (show for 1 file by hiding any sensitive data)Hello NandanHegde ,
I have one report with multiple client folders this is the ADLS gen 2 folder location for one client and data source connection: AzureStorage.DataLake for different files:
- https://lstest.dfs.core.windows.net/clientA/prepay-claim-daily/1202405300915/validated/common/fail/FileA
- https://lstest.dfs.core.windows.net/clientA/prepay-claim-daily/1202405300915/validated/common/fail/FileB
- https://lstest.dfs.core.windows.net/clientA/prepay-claim-daily/1202405300915/validated/common/fail/FileC
- https://lstest.dfs.core.windows.net/clientA/prepay-claim-daily/1202405300915/validated/common/fail/FileD
- https://lstest.dfs.core.windows.net/clientA/prepay-claim-daily/1202405300915/validated/common/fail/FileE
- https://lstest.dfs.core.windows.net/clinetA/prepay-claim-daily/1202405300915/validated/common/fail/FileF
- https://lstest.dfs.core.windows.net/clientA/prepay-claim-daily/1714506078004/validated/common/summary/SummaryFile
simillarly we have different connection string for other clients like
https://lstest.dfs.core.windows.net/clinetB/prepay-claim-daily/123456789/validated/common/fail/FileA
and so on....
This is the connection string I'm using currently for one DataSet in power BI for File A
It'll bring all the files present in the folder in this I'm filtering one file which is FileA.
I'm repeating the same steps for remaining files.
Now what I want is: in the below highlighted snip after Common_Validatons we want to add a next step
as calling Power BI report and the Common_Validations step has below variables:
we want to utilize these parameters in the connection string for Power BI dataset like below:
FileA dataset connection string like:
FileB:
FileC:
FileD:
FileE:
FileF:
1 report and 6 dataset connections (Common for all clients)
and these dataset connections need to be dynamic. That means when I run for client A report will have Client A information and the dataset connection has to pass from ADF Pipeline.
Hi Anonymous
Apologies for the inconvenience, this community is specifically for discussions and questions related to Microsoft Fabric. For queries related to Azure Data Factory we recommend using the dedicated Microsoft Q&A forum where they are ready to assist you better. Here's the link to post your query in Microsoft Q&A : Ask a question - Microsoft Q&A.
Thanks.
