Urgent: How to add custom font in the PowerBi service

[SrikanthC]

When i am trying to publish the report which is having the custom fonts in the desktop and after publishig the font disappears.
Please help if any suggestion to resolve this issue.

Thanks

[Poojara_D12]

Hi @SrikanthC 

Power BI Service does not support custom fonts, so when you publish a report with custom fonts from Power BI Desktop, the fonts may not display correctly.

Solutions:

1. Use Standard Fonts: Stick to fonts like Arial or Calibri that are supported in Power BI Service.
2. Convert Text to Images: Convert text with custom fonts into images in Power BI Desktop and upload them to the report.
3. Theme Files: Use a theme (JSON) to set consistent font styles with supported fonts.
4. Power BI Premium: Premium workspaces may offer additional features but still don't support custom fonts in the service.

If custom fonts are crucial, exporting the report to PowerPoint or PDF might retain the fonts.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[sqlaz]

When we use a custom font, say Barlow, instead of Arial or Sans Serif, the report on PowerBI service looks good - but when comes to exporting to PDF, it falls back to standard fonts.  

• Reports using themes with custom fonts will have the custom font replaced with a default font.

When are we expected to see this support for custom font on the report to export to PDF the same?   Why not render what's displayed, and why fall back to default font?  Shouldn't this be WYSIWYG?  Please advise.  Thanks!

[v-pagayam-msft]

Hi @SrikanthC ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by me and @pallavi_r . Please let me know if it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.
Regards,
Pallavi.

[v-pagayam-msft · Accepted solution]

Hi @SrikanthC   ,

Thank you for reaching out to the Microsoft Fabric Community Forum.In addition to the helpful response provided by @pallavi_r , below are the steps which might help you resolve the issue.

1.Download the Font locally and right click on it to istall.

2.Before proceding, save your work and restart Power BI so it recognizes your new font in local.

3.Create a JSON file of your current theme in Power BI

4.In the Power BI ribbon, go to View > Customize current theme and set the font like Calibri and click Apply.

5.Go back to View > Save current theme. This will generate a JSON file that you can open in Notepad++.

6.Modify the JSON file with the sample code below:

{
"name": "MyTheme",
"textClasses": {
"title": {
"fontFace": {
"fontFamily": "Calibri"
}
},
"header": {
"fontFace": {
"fontFamily": "Calibri"
}
},
"label": {
"fontFace": {
"fontFamily": "Calibri"
}
}
}
}

7.Go back to your Power BI report, again go to View > Browse for themes, and upload your edited JSON file.

The customized report will now be visible after publishing.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

[pallavi_r]

Hi @SrikanthC ,

Ideally the custom font will render the fonts on the Power BI service as expected when end user has that font installed. Can you please ensure the desktop from where you are rendering Power BI reports has font installed in the machine.

Still if that is the issue even after font installed, then you need to raise a ticket to Microsoft for this.

Custom font has limitations, it would not work on mobiles and non - window desktop.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi