When exporting data from BitaBIZ via URL we deliver hours (amounts) in this format:

100.00

This format works well with UK and USA Power BI and Excel clients. 

In central Europe / Scandinavia this format will often not work. The format in these regions are: 

100,00

Case: Change BitaBIZ dot format (100.00) to comma format (100,00)

Power BI

Change regional setting for current file:

File -> Options -> Regional Settings -> English (United States) 

This setting is per report, so other users should be able to work with this report afterwards, regardless of their locale settings. 

Excel


In your BitaBIZ dataset highlight the amount colum you need to convert to your local setting.


Click:

Data -> Convert Text to Columns -> Delimited -> Next 


Step 3 -> Advanced -> Change your Decimal and Thousands seperator 
Did this answer your question?