Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ExportReportObjects.cs: conditional formatting, RLS, OLS, and relationships not considered? #14

Open
DaniilMaslyuk opened this issue Aug 4, 2022 · 3 comments

Comments

@DaniilMaslyuk
Copy link

DaniilMaslyuk commented Aug 4, 2022

When I view ReportObjects_UnusedObjects.txt, I see columns that are part of RLS or OLS or a relationship, as well as measures that are used for conditional formatting. Is this expected?

My model has two tables:
image

In addition to the relationship, there's an RLS role, an OLS role, and a table visual with conditional formatting (background color).

I expect to see only [Unused measure] in ReportObjects_UnusedObjects, yet I see everything but 'Table'[Column for a table visual]: ReportObjects_UnusedObjects.txt

Sample PBIX file: Sample for issue 14.zip

In case it matters, I'm connecting to the model locally. The only parameters I changed were pbiFolderName, pbiFile, addPersp (the latter set to true).

Is there something I'm doing incorrectly?

@m-kovalsky
Copy link
Owner

See version 1.5.6. I've added dependencies for OLS. RLS is a bit trickier and I've logged a question within Tabular Editor's GitHub to determine the best way to accomplish this. (TabularEditor/TabularEditor#1015).

The 'column for relationship' isn't included since nothing in Table 2 is determined to be used by the report.

@m-kovalsky
Copy link
Owner

See version 1.5.7. RLS dependencies have been added.

@DaniilMaslyuk DaniilMaslyuk changed the title ExportReportObjects.cs: RLS, OLS, and relationships not considered? ExportReportObjects.cs: conditional formatting, RLS, OLS, and relationships not considered? Aug 5, 2022
@DaniilMaslyuk
Copy link
Author

Thanks, @m-kovalsky. Now just the issue of conditional formatting measures remains (somehow I failed to edit the title last time I edited the issue description). I.e. I still see a conditional formatting measure in ReportObjects_UnusedObjects.txt. Feel free to close this issue if you think it's better addressed in #13.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants