topic Re: Excel file as datasource in Report Server

Excel file as datasource

DmitryKo — Thu, 15 Sep 2022 13:30:36 GMT

PBI RS allows uploading excel files onto the server. These files are displayed at the "web portal" (/reports).
Is there a guide how to configure such excel file as a shared datasource to be used on PBI RS?

Re: Excel file as datasource

Shahfaisal — Thu, 15 Sep 2022 16:22:36 GMT

DmitryKo wrote:
PBI RS allows uploading excel files onto the server. These files are displayed at the "web portal" (/reports).
Is there a guide how to configure such excel file as a shared datasource to be used on PBI RS?

I don't think you can use an Excel file uploaded to Report Server as a data source in Power BI.

Re: Excel file as datasource

DmitryKo — Thu, 15 Sep 2022 20:18:50 GMT

Why this functionality exists then and what's the point in this?

Re: Excel file as datasource

Shahfaisal — Fri, 16 Sep 2022 02:26:30 GMT

DmitryKo wrote:
Why this functionality exists then and what's the point in this?

The portal allows other types of files such as PDF, etc too. I think the purpose is to function as a document library but most orgnizations I worked with don't use it for that purpose.

Re: Excel file as datasource

DmitryKo — Fri, 07 Oct 2022 18:45:13 GMT

OK, so the team spent some effort implementing a feature to upload and store files on the server, including Excel files, and manage it through Power BI RS "web portal" interface.

The feature is completely useless and does not fit PBI RS usage model in any way.