cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SwathiBattikadi
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? 

2 REPLIES 2
dpilats
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.
Ready!
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.

v-chuncz-msft
Community Support
Community Support

@SwathiBattikadi,

 

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

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors