Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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..
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
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!
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..
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
9 | |
5 | |
3 | |
3 |