Forum Discussion
authorization concept
You are saying that even if CRM online (that's what we're using) does require me to log in with a office 365 account when I want to get the data, it is not possible to control the connection AFTER THAT FIRST TIME when I got the data?
The connection should fail the next time a refresh is requested. The existing data is still accessible. (The same way it would be if you connected from an excel file).
That would mean that CRM by giving me the permission to have access to that data, it also gives me the permisison to give the permisison to other people in my group to see the data source and create/edit the reports?
By default, the report author passes on his permission level to the report user. UNLESS, you apply, or use, the tools to limit the view of end users. These options are.
RLS (Row Level Security) within Power BI
Direct Query to a SQL DB that supports RLS (Azure SQLDB, SQL 2016)
Live Connection to SSAS - where you would manage RLS in the model/cube
Both DQ and LC require that you manage your model/data in a different location other than in Power BI.
Anonymous & Greg_Deckler thank you for you answers.
You are saying that even if CRM online (that's what we're using) does require me to log in with a office 365 account when I want to get the data, it is not possible to control the connection AFTER THAT FIRST TIME when I got the data?
That would mean that CRM by giving me the permission to have access to that data, it also gives me the permisison to give the permisison to other people in my group to see the data source and create/edit the reports?
You are saying that even if CRM online (that's what we're using) does require me to log in with a office 365 account when I want to get the data, it is not possible to control the connection AFTER THAT FIRST TIME when I got the data?
The connection should fail the next time a refresh is requested. The existing data is still accessible. (The same way it would be if you connected from an excel file).
That would mean that CRM by giving me the permission to have access to that data, it also gives me the permisison to give the permisison to other people in my group to see the data source and create/edit the reports?
By default, the report author passes on his permission level to the report user. UNLESS, you apply, or use, the tools to limit the view of end users. These options are.
RLS (Row Level Security) within Power BI
Direct Query to a SQL DB that supports RLS (Azure SQLDB, SQL 2016)
Live Connection to SSAS - where you would manage RLS in the model/cube
Both DQ and LC require that you manage your model/data in a different location other than in Power BI.