How would you go about this process?
I have outlined my approach below, as my current challenge is making the output dynamic. At the moment it is only working if the report is static ( remains unchanged)
Project Requirement : (Iive data source)
The project aims to create an automated solution for exporting a Power BI report table to CSV format and then sending
this CSV output via email to a designated recipient. Notably, the users who will be receiving the CSV output do not possess direct access to Power BI.
Furthermore, it's essential to consider that the data presented in the Power BI report table is influenced by a slicer filter.
Thus, any modifications made to the slicer filter by the user should result in corresponding changes within the automated CSV output. For instance,
if a user specifies a particular date range in the report (e.g., Start date: 09/02/2020, End date: 08/03/2022), the data visible in the Power BI table should accurately match the data contained within the CSV output generated by the automation process.
My Current Flow:
The current workflow unfolds in the following sequence
1. A recurrence pattern acts as the triggering action.
2. Run a query against a Power BI dataset.
3. A CSV table is generated based on the results of the query.
4. (Optional) A file can be created on OneDrive.
5. An email is sent using Outlook (version 2).
Within the step "Run a Query Against a Dataset," it's essential to note that the DAX query extracted from the "performance analyzer" remains static. This implies that any alterations made to the report after its entry into the Power Automate workflow will not be mirrored in the DAX query. Consequently, the CSV output produced will not be in sync with the report's changes, especially if they result from filter adjustments.
Let me know your approach to this Thank you.
