@Anonymous wrote:
We have a powerBI report on the PowerBI report server with automatic refresh (twice a day). I understand that it is not possible to export the entire report to xls. Is there a trick to do it?
There is no trick, there is currently no way to export a pbix file directly to Excel. If you are using the January 2020 version of Report Server you can manually export a table visual from a pbix report to an Excel file, but there is a limit on the number of rows which can be exported in this way (I think it was around 150,000).
Is it possible to share the same refreshed datamodel with report builder and extract the xls from there?
No, only the cloud version of Power BI lets you connect to data models in pbix files with report builder. This is not currently support for the on-prem Report Server. The only way to achieve something like this is to setup an on-prem instance of Analysis Services in Tabular mode, then you can use this to "host" your data model and you can then connect multiple pbix reports in Live Connect mode and paginated reports (using Report Builder). And the paginated reports can then export to Excel (and you can even setup scheduled reports to automatically send out the Excel files)
