Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have a Power BI report which is getting data from one SSAS module. SSAS module is connected via 'Import' option.
Now I need to create new visuals that require new columns to be added to this SSAS model. After adding the required columns from this model, when I apply changes, it fetches all the rows and it is taking a lot of time. (There are quite many rows). Getting error as increase memory of the server where SSAS is deployed.
Is there any option to limit these rows or any way to add required columns, make visuals, Publish and then refresh the report after deploying.
Please guide.
Solved! Go to Solution.
This is because the SSAS data import feature can generate inefficient MDX when importing. A workaround is to write your own custom query, preferably using DAX.
Once you do this, I promise you'll never go back 🙂
Here's an example query you can tweak:
DEFINE
VAR vFilter1 =
FILTER ( ALL ( DimProduct[Color] ), [Color] IN { "Red", "Blue" } )
VAR vFilter2 =
FILTER (
ALL ( DimGeography[CountryRegionName] ),
[CountryRegionName] = "United States"
)
EVALUATE
SUMMARIZECOLUMNS (
DimProduct[Color],
DimProduct[Size],
DimDate[CalendarYear],
vFilter1,
vFilter2,
"Total Sales", SUM ( FactInternetSales[Sales Amount] ),
"Distinct Customers", DISTINCTCOUNT ( FactInternetSales[CustomerKey] )
)
This is because the SSAS data import feature can generate inefficient MDX when importing. A workaround is to write your own custom query, preferably using DAX.
Once you do this, I promise you'll never go back 🙂
Here's an example query you can tweak:
DEFINE
VAR vFilter1 =
FILTER ( ALL ( DimProduct[Color] ), [Color] IN { "Red", "Blue" } )
VAR vFilter2 =
FILTER (
ALL ( DimGeography[CountryRegionName] ),
[CountryRegionName] = "United States"
)
EVALUATE
SUMMARIZECOLUMNS (
DimProduct[Color],
DimProduct[Size],
DimDate[CalendarYear],
vFilter1,
vFilter2,
"Total Sales", SUM ( FactInternetSales[Sales Amount] ),
"Distinct Customers", DISTINCTCOUNT ( FactInternetSales[CustomerKey] )
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |