cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sunkim Frequent Visitor
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
Community Support Team
Community Support Team

Re: Some rows not pulling through to Power BI Desktop

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.
Sunkim Frequent Visitor
Frequent Visitor

Re: Some rows not pulling through to Power BI Desktop

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

Community Support Team
Community Support Team

Re: Some rows not pulling through to Power BI Desktop

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.
Sunkim Frequent Visitor
Frequent Visitor

Re: Some rows not pulling through to Power BI Desktop

your link seems like for linux.

Tried with new machine, fresh window installed and have same problem. 😞

Any other way to file the ticket?

tarunsingla Established Member
Established Member

Re: Some rows not pulling through to Power BI Desktop

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.

Sunkim Frequent Visitor
Frequent Visitor

Re: Some rows not pulling through to Power BI Desktop

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 Established Member
Established Member

Re: Some rows not pulling through to Power BI Desktop

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.

Sunkim Frequent Visitor
Frequent Visitor

Re: Some rows not pulling through to Power BI Desktop

Tried with iScope. Same query took 5 seconds to excuete.

of course, it is taking longer to download all result.

Sunkim Frequent Visitor
Frequent Visitor

Re: Some rows not pulling through to Power BI Desktop

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

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 154 members 1,606 guests
Please welcome our newest community members: