Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

PowerBI API for paginated reports with data in json

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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

     
     

     

     

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    1 year ago

    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