Report template dynamic Azure Storage Containers

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?

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. However, is this even possible to change the parameters of a report with a live connection?

Leave a Comment