Forum Discussion
Get data from other PBI or export table as excel template
Hi, I run my own PBI and some data is getting from other PBI dashboard by exporting table data in excel and throwing it into my sharepoint folder which is linking to my own PBI. As far as I k...
danextian
Super User
Super UserHi Anonymous ,
Use this option when exporting. The data will refresh every time you open the workbook. To be able to mimic the opening and thus trigger a refresh, add a dummy table in another worksheet and use the append a row to an Excel online table in Power Automate. Just append the current timestemp. Make sure to save this file in OneDrive for Business or SharePoint so Power Automate can access it.
Hi,
I'm trying to figure your solution but is it manual export by someone?
The purpose is to automatically get data from PBI without human engagement.
- danextian
You have to manually export it first but the data is connected live to a semantic model. Once saved in SharePoint or OneDrive, you can use Power Automate to mimic the opening of the file.