Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Claster
Advocate II
Advocate II

API Localization & Round number

Hello All. I insert data into powerbi using API and I have a some problem.
1. In my profile I set Russian localization but my dates in table look as mm.dd.yyyy, I thought if I set Russian localization that my dates should be like dd.mm.yyyy.
2. Coluld I show dates without time.

1.png

 

3. Problem with numbers in hints

2.png

4 REPLIES 4
v-haibl-msft
Microsoft Employee
Microsoft Employee

@Claster

 

  • This setting will only change the language displayed in the site but will not change your date format. Please refer to this document.
  • In PBI Service, you’re not able to change the date format. You can change the format from Date/Time to Date in PBI Desktop. Please refer to this document.
    API Localization & Round number_1.jpg
  • This setting can only control the decimal places in “data labels” but cannot impact the one in “Tooltips”. If you also want to change the one in Tooltips, we can do it in PBI Desktop.
    API Localization & Round number_2.jpgAPI Localization & Round number_3.jpg

Best Regards,

Herbert

@Herbert_Liu

I can't use PowerBI Desktop because this data set was created by PowerBI API http://docs.powerbi.apiary.io/#

In example i don't see how i could set localization and format of numbers

@Claster

 

These two functions are not supported in Service but only in Desktop. You can only change the value format in your data source but cannot do it after insert data into PBI Service. You can also vote this idea in this site.

 

Best Regards,

Herbert

@v-haibl-msft you missed KEY phrase "...I insert data into powerbi using API...". So, this guy can't use Power BI Desktop a-priory. Only JSON scripts.

 

We have similar problems to.


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.