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
Boris-Sachansky
Regular Visitor

Online Power BI report has different data format than desktop

I've developed a report with the Desktop app where I've set some data formats / visualsations etc

When I publish the report online, some of the fields have different data format than those in the Desktop file and I can't change this in the online version. Please see screenshot. How can I change data format in the online tool? Power BI online version formatting.JPG

1 ACCEPTED SOLUTION

Verify if your database (Excel) the column of date is type date or type text. My issue was because the column were text. 

View solution in original post

10 REPLIES 10
Boris-Sachansky
Regular Visitor

Actually no, it didn't work. I was just tricked by the link Power BI provides you with when you publish the report. 

This link leads to an online report which is the same as the Desktop one in terms of formatting, however if you go to the online Power BI page and open the report - its still the bugged formating.

The two links are different from each other for some reason. 

Thanks for your help, I'll try contacting the support by the link you provided me! 

Boris-Sachansky
Regular Visitor

Hold on, it actually worked! 

Thanks! 

Boris-Sachansky
Regular Visitor

Yeah column in the Excel is "Date" type... on some other places it wasn't and I changed it to "Date", but the problem persists...

Could this be because initially when uploading the data in the Power BI, it is in format "Any" and changes to "Date" when I select the first row to be Header? data type.JPG

I think no =/. Try to get suport on https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

They answer quickly by e-mail and sometimes can call for you.

Boris-Sachansky
Regular Visitor

I'm using an Excel spreadsheet, located on a SharePoint site. 

Verify if your database (Excel) the column of date is type date or type text. My issue was because the column were text. 

Boris-Sachansky
Regular Visitor

@LeonardCs - could you please advise what is the reason for this difference between online version and desktop version and if there is a way of fixing this for the online version ?
Our clients can't use the desktop version, so we're obliged to use the online one on our meetings, which is not formatted properly. .. 

Hi Boris, I was the same issue few months ago. I was using a query to export datas from SQL Server and realized that my issue was with the format inside database.

The Power BI Dasktop could fix it automatic, but the Power BI online couldn't.

What type of database are you using? SQL Server? Exel? 

Boris-Sachansky
Regular Visitor

Hi

Its Date -> Long Date .

The online version is showing the one marked in red... 

BorisSachansky_1-1713247937365.png

 

LeonardCs
Helper I
Helper I

Hi, can you show what type of date you're using on PBI Desktop?

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.

Top Solution Authors
Top Kudoed Authors