Forum Discussion
Edit query condition
Hi, I've got an issue with a table that is too hughe to load (direct query to a SSAS tabular cube), my table is "KPI" in the screenshot below. How can I say "load only data after January 1st 2...
Hi SRK_23
The screenshot you can't write MDX or DAX occurs when you try to switch SSAS connect model from "Connect Live" to "Import", i'm afraid it is not possible to do that in power bi desktop currently, you could vote the idea here.
support SSAS connect model from "Connect Live" to "Import"
Also when you connect live to SSAS, it doesn't support to connect another data source in import mode in the same pbix.
If you could accept to reconnect to the SSAS, you can consider the method of another thread of yours.
If not, you may try to select rows in Queries editor so that it would load less data into data model.
In the following code, add the bold code
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Date] > 2018/1/1 and
[Date.Year Month] <> 201601 and [Date.Year Month] <> 201602 and [Date.Year Month] <> 201603 and
[Date.Year Month] <> 201604 and [Date.Year Month] <> 201605 and [Date.Year Month] <> 201606 and
[Date.Year Month] <> 201607 and [Date.Year Month] <> 201608 and [Date.Year Month] <> 201609 and
[Date.Year Month] <> 201610 and [Date.Year Month] <> 201611 and [Date.Year Month] <> 201612))
Best regards
Maggie
Best regards
Maggie