Refreshing data issue

[Marcin]

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 is currentlu logged in :

IF(MAX(Users[Email])=LOWER(USERNAME()),1,0) 

then I used this measure as visual filter in few charts and tables.  I all works in Power BI desktop and filter works correctly. 

After publishing this report into Power BI service dataset is not refreshing and source is still Live Connection to SSAS. 

When I click "Refresh" button 

then charts show correct data, but when I go to another report or close Power BI service then problem shows again that charts show data that are not updated ... 

[v-jiascu-msft]

Hi @Marcin,

Do you mean Live Connection is Direct Query? If so, the result will be always up-to-date. Could you please post more details about the error? BTW, Direct Query needs Gateway to work.

Best Regards!

Dale

[Marcin]

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:

[v-jiascu-msft]

Hi @Marcin,

Please reference this post: Error-Unrecognized-fields-in-visual-in-powerBI. Just the same like yours. It would help.  

Best Regards!

Dale

[Marcin]

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