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: 

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.

jude_moore

Duplicates introduced by Power BI Desktop as result of loading from Dataflow

Submitted by Helper II on ‎10-09-2019 03:32 AM

Dear Microsoft 

 

Please fix this bug causing duplicate rows in the model itself when importing data from a Dataflow in the September 2019 release of Power BI Desktop 64 bit.

There are no relationships to this table ODS_WF_USERS.

Screenshots added.

Kind Regards

Jude Moore

Dupe_Issue_1.PNG

Dupe_Issue_2.PNG


Dupe_Issue_3.PNG

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎10-09-2019 10:57 PM

Hi @jude_moore, 

 

Power Query is case-sensitive while data model is not. In Query Editor, please add a index column in the ODS_WF_USERS table, apply the change. Go to Data view, filter the Name equals to 'VIRDEEM', find the returned index column values. Back to Query Editor, filter the index column with these index column values, check if related Name values are the very similar as 'VIRDEEM'. 

 

Best Regards,
Qiuyun Yu

jude_moore
Helper II
Helper II
‎10-28-2019 03:44 AM

Hi Qiuyun Yu

 

Exactly.

Screenshot 1 is Power Query and there is only one VIRDEEM. You might had expected the issue to occur, but in this case, the DAX model is the one that has the duplication issue. Please see Screenshot 2 and 3.

Thanks

Jude

Idea Statuses