Forum Discussion

BSM1985's avatar
BSM1985
Helper IV
5 years ago

Dynamic Append in Power Bi Service

Hi Team,

 

I created a report by conecting to an xls file in Power Bi Desktop and published the same to Service.

Now the requirement is, client provides a source file in xls format on monthly basis and that needs to be incorporated/appended in the report from Power BI Service itself. But the conditions from users are:

1. Do not open/touch the report in Power Bi Desktop to append the new file.

2. Do not open/touch the xls file to append the current month data

 

How we can append the data on monthly basis without touching the source file or report in Desktop. Everything should be automated without any manual intervention.

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Power BI service cannot work with xls files.   Change your process to use xlsx.

    • BSM1985's avatar
      BSM1985
      Helper IV
      5 years ago

      Hello lbendlin 

      You would mean Power Bi Service can not append the files like this and it(append) needs to be taken care of in xls itself.

      • lbendlin's avatar
        lbendlin
        Super User
        5 years ago

        That is not the point I was making. Service doesn't support the old Excel format.

         

        You can place any number of xlsx files in a folder and combine them in PowerQuery automatically.