Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Jowi
Frequent Visitor

Report template dynamic Azure Storage Containers

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?

 

 

 

 

 

 

2 REPLIES 2
Anonymous
Not applicable

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.

 

 

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.

 

 

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.