Reuse Shared dataset for paginated report and power bi reports

[Anonymous]

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!

[Anonymous]

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

[Anonymous]

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!

[Anonymous · Accepted solution]

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.. 

[jvandyck]

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?

[Hassanmoussa]

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