Forum Discussion
Helper IVDynamic name excel file extraction from power bi embedded
Bonjour à tous
serait il possible d'extraire des données à partir de tableau power bi et de sauvegarder ces données dans des fichiers ayant un nom dynamique (exemple nom de la page + date du jour) et non pas le nom par defaut data.xlsx
merci
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.
1 Reply
- edhans
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.