Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    Hi 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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        danextian
        Icon for Super User rankSuper User
        2 years ago

        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.