Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Object Level Security Preview

Hey guys i have checked the new feature about OLS -> OLS PBI    So far so good, i have managed to reproduce everything.   Here is my question, is there any way to turn the error message into some...
Data Protection
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    I can't access the share link, it requires additional verification.

    In addition, you can create some dummy data with the same data structure and paste it here in table format. Then we can copy them to build a sample file test and share.

    BTW, since this feature still in preview, I think you can contact to power bi team or submit an idea to add official support on the data connector to handle these filtered fields.
    It should more simple than manually code formula every time you change these data structures.

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Xiaoxin,
I have tried instanciation of the table in M and also by dax and any of this form still get's me the same visual error.
the dax used:

RestrictedDisBand= VAR ColName = "'Dim Discount band'[Discount Band]"
VAR ColAggregation = FIRSTNONBLANKVALUE('Dim Discount band'[Discount Band] ,1)
VAR CheckedMeasure = IF(ColName IN CALCULATETABLE(
VALUES('SecurityRestrictedObjects'[Restrict])
),
BLANK(),
ColAggregation
)
RETURN CheckedMeasure


I will continue exploring options, 

if there is any success please link it here-

 

Best regards,

 

ID

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

What type of M formula that you used in your query tables? Can you please share some dummy data with a similar data structure and highlight the fields that you setting the OLS? 

How to Get Your Question Answered Quickly

Then I can test it and try to build a template step to expand the filtered fields with blank values.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Xiaoxin,

     

    Here is the is the PBI with a test source from Microsoft example:

    PBI Test Finance 

     

    It has both the dax approach and the table instantation approach.

    The OLS applied are column level OLS on the 'Dim Discount Band'[Discount Band]

    The role is called discountband at it just set's up the column level security to None

     

    Thanks alot in Advance,

     

    Ion

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous,

      I can't access the share link, it requires additional verification.

      In addition, you can create some dummy data with the same data structure and paste it here in table format. Then we can copy them to build a sample file test and share.

      BTW, since this feature still in preview, I think you can contact to power bi team or submit an idea to add official support on the data connector to handle these filtered fields.
      It should more simple than manually code formula every time you change these data structures.

      Regards,
      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Xiaoxin,

        Yes i will preferlly do that.

        It requires alot of maintance and that is indeed counterproductive.

        I will post updates here.

         

        Thanks for the advice,

        ID