Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to Solution.
@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
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting
@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
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
37 | |
29 | |
28 | |
25 | |
22 |
User | Count |
---|---|
52 | |
51 | |
34 | |
31 | |
29 |