Hello,
I was looking for some advice on how to replace an existing report process using PowerBI cloud services.
Currently our processes is running data through Access via Microsoft SQL Studio to create tables which are then manually copied into Excel. From there, a Macro is run to create 50+ different carveouts for our metrics based on state, region and total company performance, meaning 50+ different Excel documents. Once this is done the files are uploaded to a sharepoint site and a notification email is sent to end users that the updates files are available to view.
I have recreated the ETL process of getting the data and creating the tables and have published the report to PowerBI cloud. I was looking for some advice on how to go about creating those 50+ files fro this point to be uploaded to our sharepoint site.
Thank you.
