The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 | |
14 | |
12 | |
11 | |
8 |
User | Count |
---|---|
49 | |
36 | |
22 | |
22 | |
18 |