Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
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
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:
I will continue exploring options,
if there is any success please link it here-
Best regards,
ID
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
Hi Xiaoxin,
Here is the is the PBI with a test source from Microsoft example:
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
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
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
Hi @v-shex-msft ,
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!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |