Forum Discussion
Some rows not pulling through to Power BI Desktop
I am fetching data from cosmos (single stream) to PowerBI through ODBC driver. I am getting about 1.2 mil rows and PowerBI success to load data. The problem is, stream has 1.7 mil rows. It does no...
tarunsingla
Solution Sage
Solution SageI would still try executing my query in ScopeStudio and see how long it takes. Also, not sure how many fields you have in that ss, try replacing the SELECT * with the SELECT fieldNames you are interested in.
Tried with iScope. Same query took 5 seconds to excuete.
of course, it is taking longer to download all result.