Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SSAS2012 live connection on prem

Hi there

I use PowerBI Report Server desktop to design my report. Recently I have process full my data model on SSAS server. However PowerBI doesnt seem to pick up the new data???

 

Im positive that the data is refresh cos I can see this when browse through SSMS and when I create new dashboard and connect to the same server (thru connection live) I can see the difference.

 

Have tried clear cache on desktop but still dont get the result I need. Can you please advice?


Thanks

 

Pedzilla

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    I think it is due to Filters applied to the Report. If you are using any kind of Month_Flg/Year_Flg... Please make sure they are working as expected.

    You can also cross check all the filters applied to the report..

     

    you can also try by making Maximum allowed to "0"... 

     

3 Replies

  • sbvsv's avatar
    sbvsv
    Frequent Visitor
    9 years ago

    Hi Anonymous are you using Live Connection on your Power Bi report?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        I think it is due to Filters applied to the Report. If you are using any kind of Month_Flg/Year_Flg... Please make sure they are working as expected.

        You can also cross check all the filters applied to the report..

         

        you can also try by making Maximum allowed to "0"...