Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Thanks for your reply, unfortunately that's not my requirement.
However I figured out how to do it using a combination of macros and scripts, so it's all good.
Thanks for your reply, unfortunately that's not my requirement.
However I figured out how to do it using a combination of macros and scripts, so it's all good.
@amalm,
Glad to hear the issue is solved, you can close this thread by accepting your reply as solution.
Regards,
Lydia
@amalm,
Do you want to automatically export report from Power BI to users? If so, there are some options for you.
1. Use R script in Power BI Desktop as suggested by alanhodgson in this similar thread . When you run the visual or update the dataset, it will export the data (in a table format) to a CSV or XLSX.
2. Create report in Power BI Desktop, publish the report to Power BI Service, share the report/dashboard to your clients. Or you can subscribe to dashboard or report in Power BI Service.
Regards,
Lydia
Thanks, but this seems to be for data behind visuals, if I understood it right?
My needs are much simpler - just remove a few columns from an existing excel sheet, reorder some, and then save the file again. I'm guessing there should be an easier way to do it, using PowerQuery maybe?
@amalm,
You would manually take these operations in Power BI Desktop query editor.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.