Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to Solution.
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
90 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |