Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Team,
I have configured bidirectional cross filtering in power bi and pusblish the dataset to premium workspace. While browing it in power bi reports or using desktop - bidirectional filter is working as designed however it does not work if same model is analyzed in excel. Filter context does not work in excel - it performs cross join between site organization and site table.
am I missing anything or this is bug on excel side due to way it forms the query in MDX?
I have configured the log analytics for power bi workspace to capture DAX and MDX queries generated for this issue. My conclusion is - this is analyze excel issue not having ability to pass filter context.
As you see - power bi report do pass filter context from site org to site and other way while same model analyzed in excel is performing cross join by mapping all sub departments from site with filtered dept from site org
@shrikant23 , Can share screenshot of what is not working
I do not see any limitation mentioned here
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
63 | |
52 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |