Back

Explore Courses Blog Tutorials Interview Questions

PowerQuery (in PowerBI) weird caching issue

0 votes
2 views
in BI by (11.1k points)
Power Bi is showing a cached wrong value on Power Query,because I filtered the mapping tables to only one row,I am clearing the cache and its not changing anything,How can I do that?

1 Answer

0 votes
by (22.5k points)

Hi,use the following measures

= Table.NestedJoin(#"Changed Type", {"CombinedForMerge"}, XXXXMappings, {"CombinedForMerge"}, "Changed Type", JoinKind.LeftOuter)

and

= Table.NestedJoin(XXXXMappings, {"CombinedForMerge"}, #"Changed Type", {"CombinedForMerge"}, "XXXXMappings", JoinKind.RightOuter) 

Want to learn more about Power BI? Check out today: Power BI course       

Related questions

0 votes
1 answer
Powerquery IN operator in conditional column
asked Feb 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
How to Do Countifs/Sumifs in PowerQuery M.Language Formulas?
asked Jul 8, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
Angular IE Caching issue for $http
asked Sep 3, 2019 in Web Technology by Sammy (47.6k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...