Forum Discussion
Helper IVDynamic name excel file extraction from power bi embedded
SLI wrote:
Bonjour à tous
would it be possible to extract data from power bi table and save this data in files with a dynamic name (example page name + current date) and not the name by default data.xlsx
merci
Yes, but this question might be more relevant in the Power Automate forum as I think that would be the best way to do it if you do not want to use the Analyze in Excel feature to get data.
You would need to run a query, which might be as simple as
EVALUATE YourTableNameHerethen create a file in SharePoint, then take that file and add a table to it and pass the results of the query to the Excel Create Table action in Power Automate.
But as I said, getting that to work might involve some help with the Power Automate community.
Community Champion
SLI wrote:
Bonjour à tous
would it be possible to extract data from power bi table and save this data in files with a dynamic name (example page name + current date) and not the name by default data.xlsx
merci
Yes, but this question might be more relevant in the Power Automate forum as I think that would be the best way to do it if you do not want to use the Analyze in Excel feature to get data.
You would need to run a query, which might be as simple as
EVALUATE
YourTableNameHerethen create a file in SharePoint, then take that file and add a table to it and pass the results of the query to the Excel Create Table action in Power Automate.
But as I said, getting that to work might involve some help with the Power Automate community.