Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
mosrite
Frequent Visitor

Odata query returning no records with On Premise Report Server and SSRS

Hi All

 

Have had the on Premise Power BI Report server up and running for a while with no issues (good folder structure and report, and being heavily utilised by the business)

 

We are looking at wanting to use the Rest API to query these reports for a security model using an Odata feed similar to this

http://Server/Report/api/v2.0/PowerBIReports

So to do so it appears you need SSRS installed, so we have installed SSRS (sql server report server) on the same server as our on premise PBIRS and it is working fine

I can now do an Odata feed from a powerbi report to this address http://Server/Report/api/v2.0/PowerBIReports but it retruns no data?

 

if i put the address http://Server/Report/api/v2.0/PowerBIReports in edge i get the following (so we are connecting but not pulling PBIRS data)

{"@odata.context":"http://Server/Report/api/v2.0/$metadata#PowerBIReports","value":[]}


Is there some kind of configuration needed to enable the SSRS to connect to the PBIRS database to return the Odata feed as required?


 

 

 

1 ACCEPTED SOLUTION
mosrite
Frequent Visitor

hi all

have found the issue, we dont need SSRS at all, juts needed to mod our address slightly after looking at our config through Config Manager (use webportal url, remove browse from end and /api/v2.0/PowerBIReports)

View solution in original post

2 REPLIES 2
v-xiaoyan-msft
Community Support
Community Support

Hi @mosrite ,

 

Glad you solved the problem and thank you for sharing.

 

Best Regards,
Community Support Team _ Caitlyn

mosrite
Frequent Visitor

hi all

have found the issue, we dont need SSRS at all, juts needed to mod our address slightly after looking at our config through Config Manager (use webportal url, remove browse from end and /api/v2.0/PowerBIReports)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.