You’re offline. This is a read only version of the page.
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.
Hello,
Could anyone help me?
I just create my flow, but I'm getting more than 300 different emails ...
This is my flow, anyone can help me ???
Yes, you are right. I was able to get the flow running using the button trigger. However, the stakeholder requirements prefer an automation that doesn't include any buttons.
Instead of a recurrence trigger you can experiment with a Power Automate visual (like a button) in Power BI. That allows you to transfer the prefiltered data from Power BI to your flow.
How would I about that process? Do you have any example?
Make your DAX dynamic - either by collecting user input and modifying the DAX, or by using a dynamic query in the first place.
Share
Report
All responses (
Answers (
8,101