topic Excel file as shared data source in Report Server

Excel file as shared data source

DmitryKo — Wed, 05 Oct 2022 15:01:06 GMT

Is there a step by step guide anywhere to set an Excel file as a shared datasource in PBI RS? The question is not about importing it into a single model which is obvious; it's about creating a shared datasource (New - Data Source in PBI RS menu) that can be reused to create server-wide datasets and essentially by more than one report on the server.

Re: Excel file as shared data source

d_gosbell — Thu, 06 Oct 2022 00:37:59 GMT

The data sources created in the PBIRS menu are only applicable to paginated reports. You cannot use them from Power BI Desktop based reports.

Re: Excel file as shared data source

DmitryKo — Thu, 06 Oct 2022 15:46:15 GMT

Aren't they also applicable to datasets created through the same menu and KPIs that you can create there as well? Anyways, there needs to be a recommended approach and/or step by step guide, since excel is a rather common data source for small tasks.