PowerBI API for paginated reports with data in json

[Syndicate_Admin]

Hi, I'm trying to create a paginated report (the idea is an invoice) that serves as a skeleton to be able to fill it out with json when making a request to the PowerBI api to get that report in PDF.

But I'm running into a problem and that is that I can't find information on how to create that type of paginated report which is not connected to any data source or anything.

I look forward to your contributions,

Greetings.

[Syndicate_Admin]

Good @Syndicate_Admin , It is true that the report generator does not have direct integration with the Rest API the question is to upload this report to power bi Service that does allow API, in the report a parameter would be created first, then a practically empty fictitious xml data source and in the dataset is where the data would be extracted from the parameter by Query, The fields would also be manually defined, that is a solution I have seen, I do not know if it is correct or not.

Best regards

Juan

[Anonymous]

Hi @Syndicate_Admin,  

The short answer is NO.

Report Builder does not support direct integration with REST APIs or JSON data sources, nor does it support creating paginated reports without a data source connection.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.