Hi Team,
I have 3 tables one with Employee detail(employee ID, Name, Email columns) --> this table accessiable to all.
data_access (employee and city) and another table with Country_revenue (Country, continent, revenue amount columns) deatils --> these table is accessible only for specific account when we pass the employee Id in the SQL pacakge(Pkg_data.country_data (Email))
I tried
1. DAX fucntion Userprincipalname to use as a parameter, but direct query (power editor) doesn't support it.
2. list.max but 'Failed to save modifications to the server. Error returned: 'DirectQuery partition 'xxxx-x56565x7575757575x757575' has '2' datasource reference(s) in its expression which is not allowed. ''
Can you please help, how to pass Email into this?
