Get data from other PBI or export table as excel template

[jeongkim]

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 know, there is no power automate fuction to export PBI table in excel, only PDF or something is available. 

Is there any way I can get data in excel from other PBI? maybe python script or any

[amitchandak]

@jeongkim , refer these two example

https://www.youtube.com/watch?v=cT4JdClkLh8

https://www.youtube.com/watch?v=7ddqAuMZVkk

[jeongkim]

PBI to export data is not mine so a bit different situation. 

[danextian]

Hi @jeongkim ,

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.

[jeongkim]

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.