cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yahya Kudo Kingpin
Kudo Kingpin

Changing CDS Default Currency

I posted an idea here

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Changing-CDS-Default-Currency/idi-p/355423

 

It says: -

 

After CDS data has been created in an environment, you cannot change the currency of the CDS data. If you need to change the currency, you need to delete the environment, recreate it from scratch and pick up the currency you wish.

 

With data being used and growing, this process may take you a month or 2 to complete, properly!

 

It may be hard, critical at the back-end to change the currency of the CDS data, but it is not impossible, nothing impossible I guess. I suggest that admins are allowed to change the currency of a CDS data from within the environment CDS settings, at least once. 

 

It is totally unfair that I need to create a new environment to be able to change default currency. Even Twitter/Facebook allows verified accounts change their name, once may be. Allow us change currency once, please. 

2 REPLIES 2
Community Support
Community Support

Re: Changing CDS Default Currency

Hi @Yahya ,

 

PowerApps supports the multicurrency system, each record can be associated with its own currency regard to a single currency, by using an exchange rate. That is known as the base currency. However, after the base currency is set, it can't be changed any more.

Although this is by design, I will submit your idea to the Team.

 

Best regards,

Sik 

DavidJennaway Responsive Resident
Responsive Resident

Re: Changing CDS Default Currency

As per the previous post, it is a change to the base currency that requires a new environment. This is because CDS converts all currency values to the base currency, and stores them in _base fields. 

The main use for the base currency is to allow useful reports across currency values by using the _base fields. If you don't use this, there is no need to change the base currency. Even if you do want tot report across currency values, there are 2 other options that don't require a new environment:

  • Apply exchange rates in your report, working off the originating currency fields, which you could do with SSRS or PowerBI. This has an advantage, in that you get more control over when to apply exchange rates
  • Apply exchange rates in your report, working off the base currency, but just apply an exchange rate to convert it to whatever currency you want.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Users online (6,762)