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.
