We're developing a Power BI custom connector in Visual Studio 2019 using Power Query SDK. While the inputs are first authenticated based on our logic, then it goes to the Navigation table. Here in this section for loading each table from the available list entire PQ file is called((i.e. authentication, querying) which is not optimized and best solution for the use case.
We suspect it could be due to the shared.Content is called every time. However, we are unsure about this issue's solution or root cause. Please suggest a solution to move forward by resolving this.
Also, there are no related documents on web as per our search.
