PowerBI Connector

Integrator.io
1

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

2

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 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, 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)

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.

3

Thank you. Whoever developed this Connector really need to do a better job in clear documentation :slight_smile:

4

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.