Row-Level Security with Live conection

[Anonymous]

Hey there,

I have two questions, does anybody knows if is possible to make row-level security in a live conecction mode? and the second Is there any graph that calculete the lineal regression without DAX funtions?

Thanks in advanced.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

It's possible. but for Live connections to Analysis Services are handled in the on-premises model.

please kindly refer to this article:https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular 

For the second question, you might try Scatter Plot with quick measure involved:

https://www.blue-granite.com/blog/simple-linear-regression-in-power-bi 

Also, R visual would be a better choice!

https://visualstudiomagazine.com/articles/2016/01/01/linear-regression-with-r.aspx 

[mwegener]

Hi @Anonymous ,

for live connection \ directquery. 

When the SSO option is enabled and your users access reports built atop the data source, Power BI sends their authenticated Azure AD credentials in the queries to the underlying data source. This enables Power BI to respect the security settings that are configured at the data source level.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources#single-sign-on-sso-for-directquery-sources

I do not know any graph that calculate the lineal regression without DAX function.
Maybe you can do it with the R Visual.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.