Role Filter

[Myrmelia]

Hi,

I've encounter a problem while I tried to define role by table filter. It return to me an error message.

The détails below, thanks very much

"Feedback Type:
Frown (Error)

Timestamp:
2024-07-23T11:18:03.3010907Z

Local Time:
2024-07-23T13:18:03.3010907+02:00

Session ID:
62d15ff0-8581-4203-950e-f28ebc1ff9b5

Release:
December 2023

Product Version:
2.124.1805.0 (23.12) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.JavaScriptException
at fa.error (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:12550)
at fa.tokenize (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:18586)
at fa.select (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:21411)
at fa (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:7136)
at find (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:23930)
at n.fn.init (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:24459)
at n (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:398)
at ClassSelectorBuilder.prototype.instantiate (ms-pbi://pbi.microsoft.com/ts/Shared/ClassSelectorBuilder.js:33:9)
at TablePermissionListBoxViewModel.prototype.updateFocus (ms-pbi://pbi.microsoft.com/pbi/Web/ts/FloatingDialog/KoManageRolesDialog.js:495:17)
at Anonymous function (ms-pbi://pbi.microsoft.com/pbi/Web/ts/FloatingDialog/KoManageRolesDialog.js:418:65)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.124.1805.0","ModuleName":"ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js","Component":"fa","Error":"Error","MethodDef":"error","ErrorOffset":"2:12550","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 fr-FR)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
70.8 GB

Private Memory:
658 MB

Peak Working Set:
694 MB

IE Version:
11.3636.19041.0

User ID:
19a9cbfe-dd6a-4a11-b2e2-91c907d63b79

Workbook Package Info:
1* - fr-FR, Query Groups: 1, fastCombine: Enabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_newCard
PBI_buttonSlicerAuthoring

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_backstageUI
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_modelExplorer
PBI_daxQueryView
PBI_aiNarrativesVisual
PBI_qnaImproveLsdlCopilot

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI"

[v-yetao1-msft]

Hi @Myrmelia 

Is this happening in PBI Desktop or PBI Service ?You mentioned that you are getting this error while defining the role, can you demonstrate in detail what you are doing? Or can you restore the issue by creating a simple sample? I need specific data to restore your scenario, which will help me test the issue better.

Best Regards,
Community Support Team _ Ailsa Tao

[Myrmelia]

Hi Ailsa and thanks for your support,

It happens on PBi desktop and always on third and forth sections of the table. First and second section the filter DAX expression registered correctly but on third and forth same filter on "Entreprise" dysfunction and not appears ? Names are correct. What happens ?

Thanks

[v-yetao1-msft]

Hi  @Myrmelia 

What are your third and fourth filters set to?

Best Regards,
Community Support Team _ Ailsa Tao

[Myrmelia]

Thanks for your support,

I obtain that on tables 3 and 4 :

And I can't type anything on grey window,

On tables 1 and 2, I be able to type that and it's works well :

What is the soluce for a future report ? 

Thanks

[v-yetao1-msft]

Hi @Myrmelia 

Is this your tables ? Is the table connected to another data source?Live connection mode data sources do not support setting up RLS on Desktop.

Best Regards,
Community Support Team _ Ailsa Tao

[Myrmelia]

Hi Ailsa,

Yes, it's my tables, the data source is an xls file which is located on my PC disk, not another ones, 

Thanks