Filtering on Effective User Name

[Greg_Esres]

We have a business need to show different users different data. SSAS should be able to do this, but I can't test this right now because the SSAS server isn't attached to a domain and so we can't get the Connector set up. We're working on that.

My question is: since the data these reports show is cached, wouldn't it require a refresh before the data displayed was appropriate for the user?

[Seth_C_Bauer · Accepted solution]

@Greg_Esres

By utilizing the SSAS connector the data isn't cached. The tabular model connector is a live connection in which Dax is passed back to the SSAS model to extract the information. The only things cached I believe is the dashboard tile info, and I believe that updates roughly every 10 minutes.

The reports will show the data that is in the model, so whatever frequency you have set to refresh the model, that's how often the data should be refreshed in your Power BI reports.

[Greg_Esres]

Ok, if I understand you correctly, you're saying that the preview tile may represent slightly old data (10 minutes), but when you click on it, current data will be retrieved from SSAS, filtered by any effective user name mechanism that I provide? And that this data itself might be old, depending on how often SSAS refreshes itself from the data source?

Thanks

[Seth_C_Bauer]

@Greg_Esres

In Essence, yes - there is alot to this, so I'll just point you to the in depth AS connector article which should answer all your questions and fill in any gaps for you.

https://support.powerbi.com/knowledgebase/articles/546004-power-bi-analysis-services-connector-in-de...

[Greg_Esres]

Thank you...I have actually read the Connector In Depth article, but some things don't make sense until you struggle with them in the real world for a bit. I'm sure I will need to read the article a few more times.