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 not throw any error, it completed as success.
Just missing data.
Does anyone have idea about this?
12 Replies
- v-diye-msft
Community Support
Hi Sunkim
Sorry I can't reproduce your issue, please kindly raise it to support team for better advice. thanks!
https://powerbi.microsoft.com/en-us/support/
once I click "create support ticket" I am getting this error
- v-diye-msft
Hi Sunkim
The Syntax Error Near Unexpected Token is an error that is usually encountered by the presence of misconfigured system files. These common Windows errors are usually easier to fix. If you have received a “syntax error near unexpected token” message, then there maximum chances that your computer system has some registry issues.
please refer to this post for several fixes:
https://errorcodespro.com/6-fixes-for-syntax-error-near-unexpected-token/
- tarunsingla
Solution Sage
Does your iScope query to fetch the records from the COSMOS execute in ScopeStudio ? It could be an issue with the iScope query getting timed out.
Try setting the MAXDOP to 0 to ensure the iScope script does not timeout.
Already using "[SCRIPT:MAXDOP=0]" with my query. I do not think it is timing out since it does not show any error message.
My query is simple as well. this is what I am using
"
[SCRIPT:MAXDOP=0]
SELECT *
FROM (SSTREAM "/shares/asimov.prod.data/PublicPartner/Processed/TestCommercialStores/BlackDiamond/Signup/Funnels/2019/10/PolarisFunnel2019_10_20.ss");
"
and it downloads 10mil out of 16mil.
- tarunsingla
I 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.
