SASS Cubes connection with Power BI and Limit the importing data

[danyalsaeed]

Hello,

I have multiple databases in my server, and I have to select only one of them, and then in that database I have multiple cubes, and again I have to select one particular cube, and then from that cube I have to select multiple tables with their some selective columns. 

Now there are two problems:
1. In Power BI SSAS connector we only have fields to mention Server Name and Database name, but I also have to mention the cube name, because otherwise it gets confused and generate an error (screenshot attached) when I use a table name (e.g. 'Calendar') in my DAX query, because the same table name exist in multiple cubes in that database. So, How can I do it?

2. I also have to limit the data by years, e.g. I just want to import the data for 2021, so what would be the DAX query for that?


I will really thankful to one who can help me solve this issue.

[danyalsaeed]

Here's the MDX code which has resolved my issue:

SELECT [Measures].[Revenue] ON 0,
[Customers].[City].[City] ON 1
FROM [Sales]
WHERE ( 
      strtomember("[Calendar].[YEAR].&[" + Format(now(), "yyyy") + "]")
      )

[amitchandak · Accepted solution]

@danyalsaeed , if you are using the cube, try the MDX code

Also, reprocess the cube and try