topic Re: Online Power BI report has different data format than desktop in Custom Visuals Development Discussion

Online Power BI report has different data format than desktop

Boris-Sachansky — Mon, 08 Apr 2024 10:36:39 GMT

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?

Re: Online Power BI report has different data format than desktop

LeonardCs — Fri, 12 Apr 2024 13:16:24 GMT

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

Re: Online Power BI report has different data format than desktop

Boris-Sachansky — Tue, 16 Apr 2024 06:12:29 GMT

Its Date -> Long Date .

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

Re: Online Power BI report has different data format than desktop

Boris-Sachansky — Mon, 27 May 2024 08:05:29 GMT

@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. ..

Re: Online Power BI report has different data format than desktop

LeonardCs — Mon, 27 May 2024 11:55:51 GMT

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?

Re: Online Power BI report has different data format than desktop

Boris-Sachansky — Mon, 27 May 2024 13:07:25 GMT

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

Re: Online Power BI report has different data format than desktop

LeonardCs — Mon, 27 May 2024 13:45:28 GMT

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

Re: Online Power BI report has different data format than desktop

Boris-Sachansky — Mon, 27 May 2024 14:14:33 GMT

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?

Re: Online Power BI report has different data format than desktop

LeonardCs — Mon, 27 May 2024 14:28:24 GMT

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.

Re: Online Power BI report has different data format than desktop

Boris-Sachansky — Mon, 27 May 2024 14:34:48 GMT

Hold on, it actually worked!

Thanks!

Re: Online Power BI report has different data format than desktop

Boris-Sachansky — Mon, 27 May 2024 14:49:26 GMT

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!