Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sunkim
Frequent Visitor

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 12
tarunsingla
Solution Sage
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.

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.

v-diye-msft
Community Support
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/ 

Support Ticket.gif

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

once I click "create support ticket" I am getting this errortemp.JPG

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/ 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

@v-diye-msft , any other way to file the ticket?

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.

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

@v-diye-msft 

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.