Forum Discussion

Marcin's avatar
Marcin
Helper V
9 years ago

Refreshing data issue

Hi,   I have this problem, I made a report with PowerBI desktop , data source is SSAS with Live Connection mode. In report I have created custom measure which filters data with username value that ...
Need Help
Marcin's avatar
Marcin
Helper V
9 years ago

I am using direct query to SSAS that is on Azure service so I don't need Gateway I think.  

 

This is screen from dataset options : 

 

 

But now I have changed the measure that filters data per user instead that I mentioned above  for that : 

 

 Sumx(FILTER(Events, Lower(RELATED(Users[Email]))=Lower(USERNAME())), 'Events'[Days Vacation]) 

 

and now it works , all charts are updated correctly. 

 

But there is still problem with tile's contaning data with local report measures , when I pin this tile to dashboard I get error:

 

  • Marcin's avatar
    Marcin
    Helper V
    9 years ago

    Hi v-jiascu-msft

     

    thanks for response , but I am using SSAS tabular mode and there is only one model , second thing is that this SSAS model is on Azure service so I don't need to use gateway in this case. 

     

    We don't have any on-premises serwers at this moment in my organization so I can only get data form Azure serivces.

     

    I can't create any custom measure in report because of this issue mentioned above, I have to add this measue into my SSAS model so I can use it, event for one report which is pretty uncomfortable.

     

    I will be glad for help with this case . 

     

    Marcin