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.