Share
Report
48I am trying to know if the below scenario is possible, before start digging too much on it as I know I have some work do to make it work.
I have a Power Bi report which reads the data from an Excel SharePoint file. The Excel file gets updated manually from a SSRS report. So, I am trying to automate it and looking for feasibility study on the below step:
1. Create a SSRS Subscription (Run SSRS report on a scheduled basis, save it to a folder (Network or SharePoint?)
2. Once new file created, it triggers a flow.
3. Flow creates a table with the same name as destination table name in Excel sharepoint
4. Flow finds the right table in the destination excel file (the file has multiple tables), and replace the content.
Appreciate, if anybody has done something similar that can share with me.
Thanks,
Amir
All responses (
Answers (
