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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

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
Community Champion
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.

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
Community Champion
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.

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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

Top Solution Authors