Missing rows of data when imported into PowerBI

[kasiaw29]

Hey community,

Having a strange problem. My data source is oracle database, I have a simple query that I can run in sql developer to see data before the load. One row of data (just one) is not loading into PowerBI. I can see it clearly in sql developer so wondering why it wouldn't load into PBI. In Power Query editor preview refresh was run, loaded just a minute ago and it's still not there. 

Has this happened to anyone before? 

Thanks,

Kasia 

[kasiaw29 · Accepted solution]

Hi there,

Thank you kindly for your replies. Turns out the issue was with the application I was connecting into. There was an extra layer of access on that record which funny enough prevented my PowerBI user from having access to it all together. 

[amitchandak]

@kasiaw29 , are seeing any error in power query, Some message on top of the table display.

In case you able to see some error refer these

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

[kasiaw29]

No errors in Power Query, cleared cache, loaded in again and row still not coming through. 

[v-easonf-msft]

Hi, @kasiaw29 

If you change the connection mode from  import to directquery, will the same situation occur?

Best Regards,
Community Support Team _ Eason