Using Rest API or JSON Connector with Power BI Report Builder (Paginated Reports)

[Anonymous]

Hi Experts,

We are currently using Power BI Report builder (Paginated reports) to develop reports with Marklogic as our data source.

Currently, we are creating dataset using Power BI desktop and using that dataset in report builder. The only issue here is, we can't pass parameters and fetch data using direct query to get fresh data in Report builder. We are importing whole data which results in huge dataset size.

Does report builder support REST API or can we use a JSON connector with report builder? We want to pass parameters to pull live data in Report builder?

Many thanks in advance!

[Anonymous]

Hi @Anonymous,

I checked the power bi rest API but not found corresponding methods to interact with paginated reports. (I only find the export API to export paginated reports)

For post parameter to a paginated report, you can take a look at the following links:

URL parameters in paginated reports in Power BI 

Create parameters for paginated reports in the Power BI service 

Report parameters in Power BI Report Builder 
Regards,

Xiaoxin Sheng

[Greg_Deckler]

@Anonymous I don't suppose this still works?

https://cathydumas.com/2012/03/20/using-reporting-services-with-directquery-models/

Other than that, I have nothing.

[Anonymous]

Hi @Greg, 

Yes, looks like it is currently not possible. Thanks for your reply!