Field parameters alternative using a live connection

[Smalfly]

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 parameters on article, store, .... and on the end-users language. I managed to add parameters for article, store, ... but I am struggling to get the end-users language filtering correct.

Unfortunately, I can not add multiple URLs in a "case when language = EN then use URL1 else use URL2" kind of logic.

As far as I can see, bookmarks and/or different report pages are not an option because they have different URLs and hence, would need the mentioned "case when ... then ... else .... end" logic.

Is there any alternative for field parameters using a live connection not using bookmarks?

Thanks in advance!

[ThomasWeppler]

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]

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"

[ThomasWeppler]

If you add a colum in your table you can make sure that it alway start with https://xxxx 

[Smalfly]

I don't get it. How could adding a column in my Power BI report contribute to directing the end-user towards a report page in the desired language?

[ThomasWeppler · Accepted solution]

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 🙂

[Smalfly]

That indeed helps me.

Thank you!