Forum Discussion

kd_61's avatar
kd_61
Frequent Visitor
5 years ago
Solved

Embedding Paginated Report with AppOwnsData and data gateway

I am following the tutorial for embedding a paginated report in my application. I am using the AppOwnsData sample on Github to test, and have supplied all the required settings and am using service p...
Need Help
  • kd_61's avatar
    kd_61
    5 years ago

    I solved this by downgrading the microsoft.powerbi.api nuget package from version 3.x to version 2.x. You can refer to the github issue thread for more information.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi kd_61 ,

What data source the paginated report is using? Is it a data set? If the related report was created base on the shared dataset, you can't embed it in the "App Owns Data" scenario... Please find the following documentation for the details.

Limitations and considerations

If it is a normal report, you can refer the below blog to get the dataset id.

How to find a Dataset ID in Power BI

Best Regards

kd_61's avatar
kd_61
Frequent Visitor
5 years ago

Hi Anonymous 

I am creating the reports in Power BI Report Builder and using a Miscrosoft SQL Server datasource. When I publish the reports, the datasets from the SQL Server datasource are not getting embedded with the report. Because we have the power bi on-premises gateway installed, I am able to view the published reports in Power BI Online. However, since the datasets from the SQL server datasource do not get embedded during pulish, they do not appear in the datasets section of Power BI online and I cannot get a dataset Id as described in the link you shared.

I understand that there is a limitation for using Power BI shared datasets in AppOwnsData scenarios. Is there also a limitation for using SQL Server datasources with a gateway?