Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
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.
Any other suggestions? 😞 still not getting all the rows
Tried with iScope. Same query took 5 seconds to excuete.
of course, it is taking longer to download all result.
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
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/
Hi @Sunkim
Please make sure the missing rows are not hidden. and all the tool involved is the latest version.
Please make sure you have the pro license when you creating the ticket, also plz take a try to file the ticket under anonymity.
Still unable to file the ticket 😞
I ended up with this URI
https://microsoft.sharepoint.com/sites/biatms/Pages/Resources/GetSupport.aspx
and I see this.
Should I file it with this?
your link seems like for linux.
Tried with new machine, fresh window installed and have same problem. 😞
Any other way to file the ticket?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |