Forum Discussion
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...
- 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
- 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