Dynamic Append in Power Bi Service

[BSM1985]

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.

[lbendlin]

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

[BSM1985]

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]

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.