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 something palpable ?

Example, a user that is not allowed to see the column/object, will see "*" or "Unauthorized" instead of the error

 

Thanks in advance.

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

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    Did you mean to fix the structure not match issue on query editor caused by object-level security? (power query will cache the previous structure into the query steps)

    If that is the case, I'd like to suggest creating a template table structure with all fields that use in the query table initialize, then you can use M query functions to set a default value in these fields if they are been filtered by OLS settings.

    Creating Tables In Power BI/Power Query M Code Using #table() 
    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

      I mean the visual error that appear when you apply the OLS.

      But yes, this might work.

       

      I will try and reproduce and then i will post my progress. 

       

      Thanks alot 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