Forum Discussion
teros
Helper I
8 years agoDoes REST API support on-premises Report Server?
I've just downloaded the 11/1 GA update the the on-premises Report Server and Power BI Desktop. I read a reference to a REST API -- will this work with the on-premises Report Server? Where might I f...
- 8 years ago
yes.
Chris Webb has a blog post
https://blog.crossjoin.co.uk/2017/10/15/exploring-the-new-ssrs-2017-api-in-power-bi/
I setup a connection to the Oct PowerBI RS
using http://Server/Reports/api/v2.0
and connected to an odata data source
drill into Datasets and get the ID
They use in an odata conection with open type columns (from advanced) and put your id between the brackets.
Source = OData.Feed("http://server/Reports/api/v2.0/DataSets(06ffbf58-b11a-47d0-b17c-18ff44d26c68)/data", null, [MoreColumns=true]),
And expand your columns.
see for more details
https://powerbi.microsoft.com/en-us/documentation/reportserver-access-dataset-odata/
v-qiuyu-msft
Community Support
8 years agoHi teros,
Maybe guys chrisfinmgmeyerriccardomutiJon-Heide from PG team have ideas.
Best Regards,
Qiuyun Yu