Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
RichHead1821
Resolver I
Resolver I

Is there a row limit for dataflow reading from Azure SQL table?

‎03-10-2022 01:40 AM

Hi,

I have a dataflow, which reads from an Azure SQL table, when I query the Azure SQL table directly I can see there are (currently) 114,882 rows. When I look at the table consumed via the dataflow, I can only see 45,867 rows.

Is there a limit somewhere that I have missed?

Rich

Labels:
Message 1 of 2
1,191 Views
0
1 ACCEPTED SOLUTION
RichHead1821
Resolver I
Resolver I

‎03-10-2022 02:59 AM

Sometimes I live up to my name! 🙄
There was a filter in the dataset I'd missed, which removed rows.

View solution in original post

Message 2 of 2
1,145 Views
1 REPLY 1
RichHead1821
Resolver I
Resolver I

‎03-10-2022 02:59 AM

Sometimes I live up to my name! 🙄
There was a filter in the dataset I'd missed, which removed rows.

Message 2 of 2
1,146 Views

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All