Skip to main content

Vote (0) Share
's profile image

on

Comments (0)
's profile image Profile Picture

Pär Adeen on 01 Nov 2024 10:03:16

RE:

Just got the same customer request today, i.e. to show different column headers based on a filter (dropdown filter) settings.I tried to overcome using field parameters but they I will have all field parameter columns shown when no selection is doneI also tried using bookmarks and show different visuals but that didn't work either since the filter needs to be a dropdown filterThis should be quite a simple change I would say. No need to advertise it using the function (fx) icon either, a right click on the measure will also work

's profile image Profile Picture

Pär Adeen on 01 Nov 2024 10:02:03

RE:

Just got the same customer request today, i.e. to show different column headers based on a filter (dropdown filter) settings.I tried to overcome using field parameters but they I will have all field parameter columns shown when no selection is doneI also tried using bookmarks and show different visuals but that didn't work either since the filter needs to be a dropdown filterThis should be quite a simple change I would say. No need to advertise it using the function (fx) icon either, a right click on the measure will also work

's profile image Profile Picture

Pär Adeen on 01 Nov 2024 10:00:12

RE:

Just got the same customer request today, i.e. to show different column headers based on a filter (dropdown filter) settings.I tried to overcome using field parameters but they I will have all field parameter columns shown when no selection is doneI also tried using bookmarks and show different visuals but that didn't work either since the filter needs to be a dropdown filterThis should be quite a simple change I would say. No need to advertise it using the function (fx) icon either, a right click on the measure will also work

's profile image Profile Picture

James Tomlinson on 01 Nov 2024 09:34:32

RE:

Needed by anyone managing property leases.

's profile image Profile Picture

John Shine on 01 Nov 2024 09:29:31

RE:

Essential for business that operate with housing leaseholds which can be 999 years

's profile image Profile Picture

Tomáš Žabčík on 01 Nov 2024 09:27:13

RE:

Apologies for the duplicate comment.The text did not display as I intended after I clicked Submit.Briefly: From my perspective, access to token expiration information is essential, so codeunits like codeunit 560 "CrossIntercompany Connector" in "Base Application W1-25" should avoid using constants like StandardExpirationInSeconds := 3599 to store "Token Expiration Time".

's profile image Profile Picture

Tomáš Žabčík on 01 Nov 2024 09:18:05

RE:

When the warning `"AL0432: Method 'AcquireTokenWithClientCredentials' is marked for removal. Reason: Use AcquireTokenWithClientCredentials with SecretText data type for AccessToken.. Tag: 24.0."` appears, I notice that I can no longer retrieve information about token expiration.Searching within "Base Application w1-25," I found an example in Codeunit 560, **CrossIntercompany Connector**, where expiration is handled using a constant `StandardExpirationInSeconds := 3599`.```al internal procedure GetBearerAccessToken(var ICPartner: Record "IC Partner"): SecretText var  Token: SecretText; begin  if (ICPartner."Token Expiration Time"    Token := AcquireBearerAccessToken(ICPartner);   if StoreTokenInICPartner then begin    ICPartner.SetSecret(ICPartner."Token Key", Token);    ICPartner."Token Expiration Time" := CurrentDateTime + StandardExpirationInSeconds; // StandardExpirationInSeconds is a constant.    ICPartner.Modify();   end  end  else   Token := ICPartner.GetSecret(ICPartner."Token Key");  exit(Token); end;```I'm concerned about cache issues when changing App registration because the `OAuth2` Codeunit, as I recently discovered, manages expiration internally. Knowing access token details and expiration time feels essential from my perspective.

's profile image Profile Picture

Tomáš Žabčík on 01 Nov 2024 09:14:57

RE:

When the warning `"AL0432: Method 'AcquireTokenWithClientCredentials' is marked for removal. Reason: Use AcquireTokenWithClientCredentials with SecretText data type for AccessToken.. Tag: 24.0."` appears, I notice that I can no longer retrieve information about token expiration.Searching within "Base Application w1-25," I found an example in Codeunit 560, **CrossIntercompany Connector**, where expiration is handled using a constant `StandardExpirationInSeconds := 3599`.```al  internal procedure GetBearerAccessToken(var ICPartner: Record "IC Partner"): SecretText  var    Token: SecretText;  begin    if (ICPartner."Token Expiration Time"       Token := AcquireBearerAccessToken(ICPartner);      if StoreTokenInICPartner then begin        ICPartner.SetSecret(ICPartner."Token Key", Token);        ICPartner."Token Expiration Time" := CurrentDateTime + StandardExpirationInSeconds; // StandardExpirationInSeconds is a constant.        ICPartner.Modify();      end    end    else      Token := ICPartner.GetSecret(ICPartner."Token Key");    exit(Token);  end;```I'm concerned about cache issues when changing App registration because the `OAuth2` Codeunit, as I recently discovered, manages expiration internally. Knowing access token expiration time feels essential from my perspective.

's profile image Profile Picture

Gideon Agbeshie on 01 Nov 2024 09:14:11

RE:

Dashboards with a lot of indicators need this feature. Please implement

's profile image Profile Picture

Svein Arne Hylland on 01 Nov 2024 08:06:20

RE:

USERCULTURE() returns almost what Power Bi report developers need here. Except this does not have the info of timezone or the user timezone offset from UTC.To get the current time zone offset in JavaScript, you can use the getTimezoneOffset() method of the Date object. This method returns the time zone offset in minutes from UTC for the current locale. But as Power Bi can not access resources on the local computer, I would suggest Microsoft to implement something like a USERUTCTIMEOFFSET()function in the same way it can show the USERCULTURE that then can be used in DAX to determine time difference.This can be very useful when reports are used around the world - that works interactive with live data - and displayed to user according to local time. (Otherwise any time stamps in data is useless to include.)