SSAS Project deployment not updating data within dashboard

Sha abs 26 Reputation points


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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,100 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 21,986 Reputation points

    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:

    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.



    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.

    0 comments No comments

  2. Sha abs 26 Reputation points

    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 !

    0 comments No comments