Hi Fu Chen. Don't know if you got this solved. I had the same issue, RLS was fine in PowerBI Service, but user could see everything in excel. Solution for me was: 1: Add user in workspace access with VIEWER rights 2. On the specific dataset in the workspace, ...
Hi, I believe I have solved the problem.
The solution that did the trick was not a calculated column, but a Power Query column.
Thanks to Mynda Treacy from Myonlinetraininghub for this example:
I have searched in wain for similar problems, but in wain.
I have this table:
I need a calculated ...
OK... by picking the intervals between the numbers, I could see that all results were divisible by 24. 24hrs!!! Multiply the 0,817847222 by 24 and we get 19.62833. Multiply any of the decimals by 24 and subtract the constant 0.62833 and you get the ...
Hi Importing a csv that was created via the Nordea statement "Download CSV" there is a challenge with the date format. You will see on the attached extract that the March dates are in a useable format. However the April date area converted to decimal, ...