Pushing data to a dataset automatically

[dsmhood]

I have a PowerBI push data set that I want to automatically push data to on a daily basis, I want to then generate dashboards from this data.

I am trying to push data to the API using this endpoint: "https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rows" but I am getting a HTTP/403 with the "Message":"API is not accessible for application".

I have created a Microsoft Enteprise Application (service principal), and I have granted it the Tenant.ReadWrite.All and Tenant.Read.All API permissions in EntraID for the Power BI Service. I have made the service principal an administrator in the workspace.

The service principal can create new datasets via "https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/datasets" and see the data sets but I can't seem to push data to them.

Is this a limitation of PowerBi? What am I missing?

[Anonymous]

Hi @dsmhood,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Vinay Pabbu

[Anonymous]

Hi @dsmhood,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Vinay Pabbu

[Anonymous]

Hi @dsmhood,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Vinay Pabbu

[Anonymous · Accepted solution]

Hi @dsmhood,

Thank you for reaching out to Microsoft Fabric Community Forum.

The ability to push data to a Power BI dataset using the /rows API is not supported by default for service principals. This is a known limitation in Power BI's API access model.

To enable this functionality, specific tenant-level configurations are required.

Please refer to the following Microsoft documentation, which outlines the necessary steps to configure service principal access and may help resolve the 403 error you’re encountering
Embed Power BI content in an embedded analytics application with service principal and an applicatio... 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
Vinay Pabbu

[lbendlin]

Please clarify if this is for a Push dataset or a Streaming dataset.