Forum Discussion

CLCastroEn's avatar
CLCastroEn
Helper IV
6 years ago
Solved

How to update report data automatically

Hello everyone: I have a report already ready and published in power bi so that my whole team can see the charts. The data I use is an EXCEL with many rows, more than 800,000 rows. what I have to ...
  • BA_Pete's avatar
    BA_Pete
    6 years ago

    Hi CLCastroEn ,

     

    It can be done in PBI Desktop, but it can also be done in DataFlows online in the PBI Service. The example picture I attached earlier is actually from an online DataFlow implementation where I use this technique to combine millions of rows of GPS data.

     

    Pete

Anonymous's avatar
Anonymous
Not applicable
6 years ago

This is fine, providing your column headers are all named the same, and the format is the same, 

 

just go to:
* Get Data
* either "Folder" or "SharePoint Folder"

* Select the desired folder

* Click "Combine & Transform Data" 

 

This will bring the files into one. 

 

CLCastroEn's avatar
CLCastroEn
Helper IV
6 years ago

and can I do this without entering the power bi desktop? in order to leave these processes automated. In order to only update the sharepoint data

  • BA_Pete's avatar
    BA_Pete
    Super User
    6 years ago

    Hi CLCastroEn ,

     

    It can be done in PBI Desktop, but it can also be done in DataFlows online in the PBI Service. The example picture I attached earlier is actually from an online DataFlow implementation where I use this technique to combine millions of rows of GPS data.

     

    Pete