Tabular icon indicating copy to clipboard operation
Tabular copied to clipboard

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

Open DaniilMaslyuk opened this issue 1 year ago • 3 comments

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?

DaniilMaslyuk avatar Aug 04 '22 01:08 DaniilMaslyuk

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. (https://github.com/TabularEditor/TabularEditor/issues/1015).

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

m-kovalsky avatar Aug 04 '22 11:08 m-kovalsky

See version 1.5.7. RLS dependencies have been added.

m-kovalsky avatar Aug 04 '22 12:08 m-kovalsky

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.

DaniilMaslyuk avatar Aug 05 '22 03:08 DaniilMaslyuk