Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Power BI load is very slow when connected to SSAS Tabular Model

Hi Team, 

I have been struggling with the below issue with MTD/QTD/YTD DAX formula limitations in SSAS. I have created 36 DAX Measures (MTD,QTD,YTD) in my SSAS Tabular model and when trying to pull them in desktop the performance is very slow but when i connect the report to Azure DB the performance is faster with the below formula(Formula 1). 

Used below formula for MTD/QTD/YTD calculations in Power BI:

Formula 1: MTDSales=TotalMTD(GrossSales,TableName(Date).[Date]) -- Performance is fast in Power BI with this formula


Whereas in SSAS I can write below formula,

Formula 2: MTDSales=TotalMTD(GrossSales,TableName(Date)) (unable to get .[Date] extension here).


From my observations MTD/QTD/YTD calculations are very slow when used Formula 2 even in Power BI but the queries work faster when used Formula 1. Can someone please assist me how can i achive this in SSAS? 

Frequent Visitor

I will share my case. My report was very slow. I also "Specified Mark as Date Table for use with Time Intelligence". Did not help.
The problem was due to custom filter "Smart filter by OKViz". I deleted it and performance was fantastic again.
I suggest to use filter panel.
Step 1: open power bi options - Global
Step 2: Preview features - Select "New filter experiance". Restart PowerBI.
Step 3. open power bi options - current file - select "enable the updated filter pane". Restart if required.
Get rid of filter box on every page, use only this pane and enjoy.
All calculation dax logic should be on AS side, no Power BI dax'ing.

Community Support
Community Support



You may take a look at Specify Mark as Date Table for use with Time Intelligence.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors