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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Copycat
Frequent Visitor

Data difference between dataset and report

Good day beautiful people,

 

I have dataset and live connected report to it.

My main issue is that the report data is slightly different and I have no idea how to validate, where the change occurs.

 

Dataset table:

Customer NameCustomer IDValue CheckedCheck Key
microsoft123456microsoftCustomer Name must be in capital letters
Apple789456AppleCustomer Name must be in capital letters
sony764542sonyCustomer Name must be in capital letters

Report table:

Customer NameCustomer IDValue CheckedCheck Key
MICROSOFT123456MICROSOFTCustomer Name must be in capital letters
APPLE789456APPLECustomer Name must be in capital letters
sony764542sonyCustomer Name must be in capital letters

 

Microsoft - incorrect

Apple - incorrect

Sony - correct

 

This table is designed to list all the Customer Names, which failed to pass the Check Key test. In this very example, I'm checking if the Customer Name is in capital letters.

The issue I have, is that there are 2 records which are not correct between dataset and report, while 900+ are still correct and showing correct values.

In the report table both Microsoft and Apple should NOT be in capital letters, just like in dataset table.

 

I have refreshed DB, dataset, report, PQ few times but this error keeps persist.

To continue testing, I have made new table and filtered it just to show the troublesome records - in dataset everything is fine, while report still shows incorrect stuff.

 

What could happen in the report, that could change just these 2 records? I've tried to lookup for any changes or data modification things but since it is live connected, most of the options are disabled.

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

Hi @Copycat ,

 

Case sensitivity is one of the more confusing aspects of Power BI: while the Power Query engine is case sensitive, the main Power BI engine (that means datasets, relationships, DAX etc) is case insensitive.

Maybe you can change the connection mode of your dataset or add some tag to help recognize these data in your data source and the use the DAX function UPPER or LOWER to transform your data.

 

For more details, please refer to:

Power BI And Case Sensitivity - Chris Webb's BI Blog (crossjoin.co.uk)

 

Best Regards,

Jianbo Li

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

1 REPLY 1
v-jianboli-msft
Community Support
Community Support

Hi @Copycat ,

 

Case sensitivity is one of the more confusing aspects of Power BI: while the Power Query engine is case sensitive, the main Power BI engine (that means datasets, relationships, DAX etc) is case insensitive.

Maybe you can change the connection mode of your dataset or add some tag to help recognize these data in your data source and the use the DAX function UPPER or LOWER to transform your data.

 

For more details, please refer to:

Power BI And Case Sensitivity - Chris Webb's BI Blog (crossjoin.co.uk)

 

Best Regards,

Jianbo Li

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.