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.
Does anyone know how to force the cache that stores data for DAX to flush and use what is coming from the Query engine?
We had most of our items in all caps and to make reports more readable, we've changed them in our ERP system. As you can see on the right side of this picture, the case is correct. "3 Tier Spice Rack." However, when it flows through to the PowerPivot/DAX engine of Power BI Desktop, it retains the ALLCAPS text in the visuals, on the left.
A few notes:
This is not a new issue. Has been going on for a few months - the few months since we changed case, so this has been through the Sept 2017 - Jan 2018 PBI Desktop app as well as the 4-5 Gateways for on-prem data.
Any ideas?
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @edhans,
I am still a little confusing. What operation in Query Editor which lead to change the case of text? It will display the same with text in Data area. Please click "Date" button(highlighted in red line) and view what the data look like?
Best Regards,
Angelia
There is no query operation going on to change the case of the text.
If I write a new report with a fresh PBIX file, it works fine.
It is like the DAX engine is caching data and it is using a checksum of the characters in the field, but it isn't case sensitive, so it isn't working right.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |