Forum Discussion

Smalfly's avatar
Smalfly
Icon for Responsive Resident rankResponsive Resident
1 year ago
Solved

Field parameters alternative using a live connection

Hi all,   I have a large sales cube on which I need to build a multi language report that I need to be able to parameterize by language.   Simply said, I need a URL that contains certain paramete...
Need Help
  • ThomasWeppler's avatar
    ThomasWeppler
    1 year ago

    I see I think I misunderstood you.
    If you only are into changeing the set-up bassed on the end user you need to look into row level security.
    https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security

    That will allow you to only load specific rows bassed on which e-mail addrese the end user logs in with.

     

    Than you can add a table with the following columns. 

    User, e-mail, languish, url.

    Than you just use the first row in the url column to get them to their page. (their is only one per user if you set row level security up correctly.)

    I hope this help 🙂

     

     

     

     

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
1 year ago

Why can you not add multiple urls?

Something like this could work as a measure.

 

url =
IF (
SELECTEDVALUE ( 'Table'[langueage] ) = "En",
"Https://url1",
IF ( SELECTEDVALUE ( 'Table'[langueage] ) = "Fr", "Https://url2", BLANK () )
)

 

 

Smalfly's avatar
Smalfly
Icon for Responsive Resident rankResponsive Resident
1 year ago

Thank you for your suggestion. That would work if I was able to use a measure.

 

However, I am going to use the URL in an application that does a check on the URL structure's validity before saving it. It needs to start with https://xxxx so ideally, I end up with a language parameter and have a URL like https://xxxx&filter=language eq "En"