Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
SLI
Helper IV
Helper IV

Dynamic 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 

1 ACCEPTED SOLUTION
edhans
Super User
Super User


@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.

edhans_0-1654272070872.png

 

You would need to run a query, which might be as simple as 

EVALUATE
YourTableNameHere

then 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.

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

1 REPLY 1
edhans
Super User
Super User


@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.

edhans_0-1654272070872.png

 

You would need to run a query, which might be as simple as 

EVALUATE
YourTableNameHere

then 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.

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.