Forum Discussion
Sharing chart along with underlying data via email using Power Automate
yes I'm talking about exporting underlying data along with chart on a scheduled basis.
Super UserWell If you have the visual on a single page and you know the DAX behind the visual (you can get it from the Performance Analyzer), then you might be able to build a big Power Automate Flow that would export to PDF de visual and executeQueries for the dataset and render a csv like the following example:
Exporting to csv: https://www.datalineo.com/post/using-power-automate-to-run-dax-queries-against-your-power-bi-dataset
Storing on sharepoint: https://www.fourmoo.com/2022/06/15/exporting-a-power-bi-visual-data-to-a-csv-file-in-sharepoint/
I hope that helps,
Hi ibarrau
By using the above method (i.e. DAX query using performance analyzer) we can only share the data shown in the visual. But I want to send the underlying data.
Is there any workaround for this?
Thanks!
- ibarrau
Hi. By the above method you can query whatever data you want with the DAX query. The idea of getting that from the performance analyzer is an example of getting the data from the visual. You can build any query you want. The important thing are the links that will let you build the trigger.
You can open DAX Studio and connect the Desktop or premium model. Start querying the data untill you have what you want to send. Then just build it.
I hope that helps,