Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a data source coming in from an SSAS cube.
I'm able to add filters to reports' URLs and filter on the Year dimension, but not others.
My URL is in the form of
https://app.powerbi.com/groups/me/reports/<REPORTID>/ReportSection?filter=DimDate/Year eq '2018' and DimGeography/Continent eq 'Asia' and DimCurrency/Currency eq 'Euro'
No matter if I use all the filters or only one at a time, the report only ever gets filtered on the year, and gives an error on the other two filters:
As you can tell in the screenshot, Power BI recognizes the DimGeography table. (If I use an invalid table name, the tooltip that is here displaying 'DimGeography'[Undefined] doesn't appear at all).
I made a point to only try fields that don't have spaces in their names, and I was diligent about being case-sensitive.
I also tried clearing Chrome's cache and trying in Firefox, based on previous discussions in the forum.
Any idea what I might be doing wrong, or what might need to be changed in the data-types/ meta-data/ anything on the cube-side, in order to get this to work?
Thanks!
Hi @ethan1701,
What is the data type of [Continent] and [Currency]? Please locate to Power Query editor to check if there existing any error when loading dataset. Also, please connect to this SSAS cube again in a new .pbix file to see whether problem persists.
Regards,
Yuliana Gu
User | Count |
---|---|
36 | |
31 | |
28 | |
25 | |
25 |
User | Count |
---|---|
52 | |
50 | |
37 | |
36 | |
30 |