cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ecarpz71
New Member

Data limit or is it?

HI,

 

Im new to using PowerBI desktop so hopefully someone can just point me to the right link here to get my answer. Will very much appreciate it.

 

My concern is im using Power BI desktop and I get my data from Microsoft Azure Sql Database. I connect to it and use Direct Query. Im able to load the tables a view data. However, Im wiered out that sometimes the record Im looking for is present and sometimes its not. Is that because I hit the 1 million mark already of rows that can be returned? I doubt that since im just using a QA database and the system is fairly new. I know that the record is present because I can still see the record from the UI that connects to the database.

 

Thank you in advance.

1 REPLY 1
v-huizhn-msft
Microsoft
Microsoft

Hi @Ecarpz71,

There is a 1 million row limit for returning data when using DirectQuery. If more than 1 million rows would be returned from DirectQuery, Power BI returns an error. So you'd better to filter your data using T-SQL, and decide which row will be returned. 

Best Regards,
Angelia



Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!