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