topic Re: Pushing data to a dataset automatically in Developer

Pushing data to a dataset automatically

dsmhood — Thu, 17 Apr 2025 13:58:44 GMT

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?

Re: Pushing data to a dataset automatically

lbendlin — Thu, 17 Apr 2025 19:55:19 GMT

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

Re: Pushing data to a dataset automatically

Anonymous — Mon, 21 Apr 2025 07:17:34 GMT

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 application secret - Power BI | Microsoft Learn

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

Re: Pushing data to a dataset automatically

Anonymous — Fri, 25 Apr 2025 11:03:15 GMT

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

Re: Pushing data to a dataset automatically

Anonymous — Tue, 29 Apr 2025 10:28:14 GMT

Hi @dsmhood,

Regards,
Vinay Pabbu

Re: Pushing data to a dataset automatically

Anonymous — Fri, 02 May 2025 11:32:57 GMT

Hi @dsmhood,

Regards,
Vinay Pabbu