Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
@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
No errors in Power Query, cleared cache, loaded in again and row still not coming through.
Hi, @kasiaw29
If you change the connection mode from import to directquery, will the same situation occur?
Best Regards,
Community Support Team _ Eason
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |