Report template dynamic Azure Storage Containers

[Jowi]

Hi, I am a bit lost so hopefully someone on here can give me some guidance and point me in the right direction.

I am automating a workflow for a tool that collects data from clients' Azure environments via a multi-tenant application. We achieve this using a series of Azure Functions, and the output data is stored on Azure Storage. We create a container for each client where the files are stored. However, the filenames are always the same; only the container name varies for each client.

Example:

• Container\ClientA\UserInformation.csv
• Container\ClientB\UserInformation.csv

We would like to embed Power BI dashboards/reports in a webpage and provide clients access to view their results. We have been attempting to build a report template in Power BI, but we are stuck on how to handle dynamic paths. Therefore, we are wondering if this is even a good approach, or if we should instead write the data to, for example, Data Explorer and have Power BI query the data from there.

We currently have Azure Functions set up to create a workspace per client with the appropriate permissions. Ideally, we would also automatically upload a report template that populates based on the data stored in the Storage Container for each client. What would be the best approach for achieving this?

[Anonymous]

Hi @Jowi 

Perhaps the following document can help you:

Solved: Connecting to Azure blob storage - Microsoft Fabric Community

Create and use report templates in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

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

[Jowi]

Hi @Anonymous , thank you very much for your response. The main issue I am running into is how I can change the parameters without opening the report template. It's possible for a data source via the Power BI REST API, but not for the report as far as I am aware.

In my report template, I created a parameter called ContainerName. I only need to change the value for this to load the data for the new clients. I am trying to do this as part of my Azure function. After creating the new workspace and moving the report template there, I need to modify the parameter so it's pointing at the correct data.