# PowerBI Connector **URL:** \ **Category:** Integrator.io\ **Tags:** microsoft-power-bi\ **Created:** [February 26, 2026, 12:12am UTC](https://connective.celigo.com/t/powerbi-connector/6097 "2026-02-26T00:12:47Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Vreddhi\_Bhat](https://avatars.discourse-cdn.com/v4/letter/v/a698b9/32.png) [@Vreddhi\_Bhat](https://connective.celigo.com/u/Vreddhi_Bhat)\ **Post date:** [February 26, 2026, 12:12am UTC](https://connective.celigo.com/t/powerbi-connector/6097/1 "2026-02-26T00:12:48Z")
I am trying to load data into PowerBI table. I do see there is load table option in the connector. But there is no documentation around whether the connector automatically sends the data as a file object? Microsoft APIs seem to expect the file object though ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [March 4, 2026, 6:00am UTC](https://connective.celigo.com/t/powerbi-connector/6097/2 "2026-03-04T06:00:10Z")
Hey @Vreddhi_Bhat — good question. The Power BI connector's "load table" option uses the **Push Datasets API** under the hood, specifically the [Post Rows](https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-post-rows) endpoint. It sends the data as a JSON payload (an array of row objects), **not** as a file object. So you don't need to worry about constructing a file — the connector handles the serialization for you. You might be thinking of the [Imports API](https://learn.microsoft.com/en-us/rest/api/power-bi/imports), which _does_ expect a file (PBIX, Excel, CSV, etc.), but that's a different endpoint entirely and isn't what the connector's "load table" action uses. A few things to keep in mind with the Push Datasets approach: - The target dataset in Power BI needs to be a **push dataset** (created via the API, not through Power BI Desktop) - There's a **200,000 row limit** per table and **10,000 rows per POST** request - There's still no "update row" endpoint — only add rows and delete all rows (same limitation we discussed [previously](https://connective.celigo.com/t/connection-to-powerbi/395)) If you're working with larger volumes or need incremental updates, routing through a data warehouse (Snowflake, BigQuery, etc.) and connecting Power BI to that is still the more robust path. ---
**Author:** ![Vreddhi\_Bhat](https://avatars.discourse-cdn.com/v4/letter/v/a698b9/32.png) [@Vreddhi\_Bhat](https://connective.celigo.com/u/Vreddhi_Bhat)\ **Post date:** [March 4, 2026, 1:32pm UTC](https://connective.celigo.com/t/powerbi-connector/6097/3 "2026-03-04T13:32:01Z")
Thank you. Whoever developed this Connector really need to do a better job in clear documentation 🙂 ---
**Author:** ![Vreddhi\_Bhat](https://avatars.discourse-cdn.com/v4/letter/v/a698b9/32.png) [@Vreddhi\_Bhat](https://connective.celigo.com/u/Vreddhi_Bhat)\ **Post date:** [March 4, 2026, 1:39pm UTC](https://connective.celigo.com/t/powerbi-connector/6097/4 "2026-03-04T13:39:55Z")
Also, would it be possible for someone to maybe share an article with example usage of this connector. When trying to transfer data, it still errors our due to some typical Microsoft nuances.