Forum Discussion

Copycat's avatar
Copycat
Frequent Visitor
3 years ago
Solved

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...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.