Forum Discussion

SupriyaChaugule's avatar
SupriyaChaugule
Frequent Visitor
1 year ago
Solved

Optimizing Power BI Custom Connector Performance for Faster Data Loading

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...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    - 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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
v-achippa
Community Support
1 year ago

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's avatar
    v-achippa
    Community Support
    1 year ago

    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's avatar
      v-achippa
      Community Support
      1 year ago

      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