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

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

Anonymous — Thu, 10 Sep 2020 08:11:02 GMT

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!

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

Greg_Deckler — Thu, 10 Sep 2020 18:42:46 GMT

@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.

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

Anonymous — Sun, 13 Sep 2020 08:08:11 GMT

Hi @Greg,

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

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

Anonymous — Wed, 16 Sep 2020 08:18:09 GMT

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