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?
