topic Reuse Shared dataset for paginated report and power bi reports in Report Server

Reuse Shared dataset for paginated report and power bi reports

Anonymous — Thu, 15 Mar 2018 15:37:58 GMT

Hi,

We wanted some reports in paginated and few in power bi from same datasource queries.

I created a shared dataset from BIDS and deployed it to report server. I am able to use it for Paginaged reports.

How do i connect to this shared dataset from Power BI?

Simple question is - can i create a shared dataset and use if for both Paginated and Power BI in report server?

Thanks!

Re: Reuse Shared dataset for paginated report and power bi reports

Anonymous — Fri, 16 Mar 2018 08:40:38 GMT

Hi Anonymous

The option of reusing datasets for Power BI reports is not currently supported in PBIRS. We all hope this will be possible in the near future :)

Regards,

Maria

Re: Reuse Shared dataset for paginated report and power bi reports

Anonymous — Fri, 16 Mar 2018 15:59:58 GMT

Hi Anonymous

Yes, thanks for the reply.

But my question is slightly different here - can we create a Report model (just a join query from multiple sources) and then use it in Power BI (instead of connection to DB's again)?

I mean can Power BI connect to .RDS?

Thanks!

Re: Reuse Shared dataset for paginated report and power bi reports

Anonymous — Mon, 19 Mar 2018 10:13:28 GMT

Hi Anonymous,

There is a possibility to use the OData connector, e.g. you create your dataset, save it on PBIRS (.RSD) and then access it in Power BI Desktop using a similar path: http://SampleReportServer/reports/api/v2.0/datasets(Path='/SampleDataset')/data (basically a JSON object).

Not so straightforward but still useful in some cases..

Re: Reuse Shared dataset for paginated report and power bi reports

jvandyck — Thu, 24 May 2018 09:08:33 GMT

I cannot get this to work. I have a dataset on the following location: http://bi04rs.global.dns/Reports/_BICC/opportuniteiten.

What would the URL then be to set up the odata source?

Re: Reuse Shared dataset for paginated report and power bi reports

Hassanmoussa — Mon, 07 Jun 2021 08:20:35 GMT

Please use the below format when you want to connect to youre PBIRS datasets as OData feeds in PBI Desktop:

https://myorg.com/reports/api/v2.0/datasets(Path='/Folder/DataSetName')/data

Also please make sure to select "icnlude open type columns". Otherwise it won't work. See below screenshot