cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
manalla Regular Visitor
Regular Visitor

Reuse Shared dataset for paginated report and power bi reports

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!

1 ACCEPTED SOLUTION

Accepted Solutions
mrphinche Regular Visitor
Regular Visitor

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

Hi @manalla,

 

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

4 REPLIES 4
mrphinche Regular Visitor
Regular Visitor

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

Hi @manalla

 

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 Smiley Happy

 

Regards,

Maria

manalla Regular Visitor
Regular Visitor

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

Hi @mrphinche

 

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!

mrphinche Regular Visitor
Regular Visitor

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

Hi @manalla,

 

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 Regular Visitor
Regular Visitor

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

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?