Diagnositc tool show several querys to the data source

[Mornagli]

Hello, im getting my data with odata connector, due to low performance and errors in the data source when i try to get my data, i create smaller querys to the server: 
Instead : odata.feed(https/mysourcepath/tablename) --> 

Create this query: odata.feed(https/mysourcepath/tablename?$select=colA,colB&$expand=subtable...)  in ordere to reduce traffic to the data source.

When i activate the diagnostic tool, for some reason i see that PBI send my new querys but also i see querys to get full metadata (e.g https/mysourcepath/tablename), why is that? 

I think that this requests create errors in the data source.

And another question about the querys, when i add the $expand to one of the querys(odata.feed(https/mysourcepath/tablename?$select=colA,colB&$expand=subtable...)), the time that take to PBI to get the data is much much longer, can i reduce it? 

Thank you.

[Anonymous · Accepted solution]

Hi  @Mornagli ,

This is the related document, you can view this content:

https://docs.microsoft.com/en-us/power-query/QueryDiagnostics

https://docs.microsoft.com/en-us/power-query/readingquerydiagnostics

https://docs.microsoft.com/en-us/power-query/recordingquerydiagnostics

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.