Forum Discussion
how to insert measure values into a table after each refresh (sheduled or not)
Hi , megerwan
If you want to get the measure data in your visual after the dataset refresh.
If you only need the data , can you accrpt the snap image of the report , not a table.
If this, you can try to use the "Email Subscription" in the report to send an snap to your email after refreshing the dataset.
For more information, you can refer to :
Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn
You can also use Power Automate to refresh the dataset and then you can configuire "export file to PDF" in Power Automate.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Solution SageNo. Power BI does not like what you're trying to do. Tables should be structured differently in PBI.
Instead of:
date | value_measure1 | value_measure2...
Such a table would have to expand to the right with more and more columns.
You should go for something different:
date | measure_name | measure_value
Such a table will not expand to the right. You will only add new rows and the table schema will be set in stone.
Good point. but how to insert the value in the table ?