Optimizing Power BI Custom Connector Performance for Faster Data Loading

[SupriyaChaugule]

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!

[Anonymous]

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

[v-achippa]

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

[v-achippa]

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

[v-achippa]

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

[lbendlin · Accepted solution]

- 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