SSAS Project deployment not updating data within dashboard

Question

Hello,

My SSAS project contains different measures which were blank because of date shift, After fixing all calculations I deployed the project in SDT to Microsoft Analysis service (on Local machine) from which Power-BI connects to the model and consume live data

Power-BI Dashboard is Not refreshing the measures (they stay Blank) for some reason, I tried closing the Dashboard and opening again and refreshing, nothing changed.

what could be the problem ? I haven't encountered such a problem ever

your help appreciated :0

Answer 1

Hi @Sha abs ,

First, please confirm your SSAS database contain the data, connect to SSAS via SSMS, then run a query as below to see if it can return any data:

EVALUATE  
ROW ( "Total YTD", 'Usage'[TotalYTD]  

If it does not return any data, you may need to confirm the processing to see if you have set to the correct SSAS server.

If it does return data, then you may need to check your Power BI report to see if there are any issues with your Power BI report.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @ZoeHui-MSFT ,

Thank you for the help appreciated ! :)

I ran what you asked in SSMS engine and Didn't get any result opposing to what is shown in SSAS Project !

I made sure to process all the data in SSAS (all partitions & Tables) and Deploy it to My machine (shown as "TheVoiceTabular" in SSMS)- All this is made under the Default perspective of course

I don't know what to do now, I made sure to calculate YTD in two different ways in order to prevent any troubles in the calculations as below:

Option 1: TotalYtd = TOTALYTD(Sum(Usage[rev]),'Date'[Date])
Option 2: Cal YTD = CALCULATE(SUM(Usage[rev]),DATESYTD('Date'[Date]))

• Both calculation give the same value in SSAS which equals 6,752. For you to see I am attaching a picture of the
  measures included in a Matrix within PowerBi and Cards- Somehow YTD is present on the Matrix and Blank valued on Card visualizations, Notice also That 'Rev' column isn't complete in PowerBi which isn't the case in SSAS nor in SSMS
  

Even when using the dates column from the Fact table My data is missing (Not all dates are presented) for example
KeyCallDate= 20131231 should exist in PowerBi see Pic.

thank you !