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

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
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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 🙂

 

Regards,

Maria

manalla Member
Member

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

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
Not applicable

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

View solution in original post

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?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!