topic Re: Optimizing Power BI Custom Connector Performance for Faster Data Loading in Developer

Optimizing Power BI Custom Connector Performance for Faster Data Loading

SupriyaChaugule — Fri, 07 Mar 2025 07:02:49 GMT

I am building a custom Power BI connector to fetch data from an API. While fetching data from the API is relatively fast, the process of loading it into Power BI takes a significant amount of time. I am looking for ways to optimize the data loading process.

Are there best practices to improve performance when loading data into Power BI from a custom connector? Additionally, are there alternative ways to structure the JSON data output from the API to make it more efficient for Power BI processing?

Any insights or recommendations on optimizing data loading performance in Power BI would be greatly appreciated!

Re: Optimizing Power BI Custom Connector Performance for Faster Data Loading

lbendlin — Fri, 07 Mar 2025 15:31:55 GMT

- structure your JSON so it represents simple arrays. Avoid multi level nesting

- consider using data extracts for immutable data to avoid pulling the same data over and over again

- experiment with the record count - your API may have a performance sweet spot there

Re: Optimizing Power BI Custom Connector Performance for Faster Data Loading

Anonymous — Mon, 10 Mar 2025 06:35:19 GMT

Hi @SupriyaChaugule ,

Did lbendlin 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

Regards,

Xiaoxin Sheng

Re: Optimizing Power BI Custom Connector Performance for Faster Data Loading

v-achippa — Mon, 21 Apr 2025 13:39:41 GMT

Hi @SupriyaChaugule,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

Re: Optimizing Power BI Custom Connector Performance for Faster Data Loading

v-achippa — Thu, 24 Apr 2025 14:24:40 GMT

Hi @SupriyaChaugule,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

Re: Optimizing Power BI Custom Connector Performance for Faster Data Loading

v-achippa — Mon, 28 Apr 2025 13:01:02 GMT

Hi @SupriyaChaugule,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa