Power BI Report using SSRS Shared Dataset in Power BI Report Server

Check this video to know how to use SSRS Shared Datasets as a source for your Power BI Report.

Also, see how the Odata feed data connector has been used to achieve the result.

Power BI Report Server

SSRS 2017 Features

SSRS 2017 REST APIs

[JamieBorg]

I appreciate this demo and the solution it provided for my use-case. I did use the web import option though rather than the odata option. However I would not have gotten that far without this video.

[nandkishorpatil]

Thank you so much sir.This is very valuable information.Helped me lot.💐💐💐

[humanbeing]

Thank you very much, this was very helpful!

[georgeibrahim]

I have used this but when you publish a data set, what are the username and password to use. I noticed yours had errors on the refresh and I can not get my refresh to work. I can get the data source connection to test successfully.

[timd]

How do we edit the API to get the cache shared datasets we scheduled on Power BI Report Server?

[robertbarkovicz]

Thank you very much, this was a really useful video which helped me a lot!
By the way, it does work on SSRS as well, not only on PBIRS.
I have a datatime value in my columns, this is rendered as "10/22/2020 8:16:01 AM" from the REST API. Do you know whether it is possible to change the format dates are rendered?

[original]

Hi, I have a 404 error when I type /data in the URL. The previous steps are ok. An idea? Thanks!

[pranavnair]

Is export to pdf available in power bi report server?

[GvOG]

I have timeout problems when i load more than 100k rows. How to fix that?
Details: "OData: Request failed: The operation has timed out"

[sharmajiamit]

if i want to publish the power bi report to another server then how can i change dynamically the odata string acording to the new server