Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
BilboBaggins
Frequent Visitor

Different amount of rows from same SQL table

Hi!

 

I have a problem that I don't understand. 

 

If I just import the table, it shows 1796 rows in Power BI. Every row in the table are unique. (WRONG AMOUNT OF ROWS)

 

let
    Source = Sql.Databases("xxxxx.database.windows.net"),
    #"localization-sd-pilot-db" = Source{[Name="localization-sd-pilot-db"]}[Data],
    dbo_LocalizationItems = #"localization-sd-pilot-db"{[Schema="dbo",Item="LocalizationItems"]}[Data]
in
    dbo_LocalizationItems

But if I import the same table with SQL clause, it show 2304 rows. (CORRECT AMOUNT)

 

let
    Source = Sql.Database("xxxxx.database.windows.net", "zzzzz", [Query="SELECT [Id]#(lf)      ,[ExternalId]#(lf)  FROM [dbo].[LocalizationItems]", CreateNavigationProperties=false])
in
    Source

Isn't the first option supposed to give me the whole table? I have the latest version of Power BI desktop installed.

 

Thanks in advance!

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@BilboBaggins,

 

I have made a table with some duplicate rows in sql server and import the table into power bi, but couldn't reproduce your issue, duplicate rows still exist in power bi on my side. Could you show a sample of table structure for further analysis?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@BilboBaggins,

 

I have made a table with some duplicate rows in sql server and import the table into power bi, but couldn't reproduce your issue, duplicate rows still exist in power bi on my side. Could you show a sample of table structure for further analysis?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

OK, new day and fresh pair of eyes. 

 

The DB structure has changed, and I made the import and query from different databases. The tables were identically named and this lead to my confusion. So everything is working fine, the error code was PEBMAC. Robot LOL

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.