Format Date fields in a shared PowerBI dataset with read-only permission

[AdrianSantos___]

Hello everyone,

I work with a shared PowerBI dataset with read-only permission, therefore I cannot edit or format any fields.

My issue here is with the data fields, that are formated as Date/Time and therefore will show up with either as a hierachy (4 fields) or a full date with time included.

 

There is no dimensional table for the dates, all dates are fields within the fact table. I wish to present the dates as a DD/MM/YYYY format without the time stamp but I cannot format the field, and trying to create a measure formating the date or extracting the month does not work. Could there be any solutions other than ask for a format change in the source?

Thank you!

[v-luwang-msft · Accepted solution]

Hi @AdrianSantos___ ,

test measure like below:

Measure = FORMAT(MAX(table2[Date]),"DD/MM/YYYY")

Use account:

Dataset:

Permission(read-only):

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[AdrianSantos___]

Hello @v-luwang-msft thank you for your reply! That's a pretty ingenious workaround for the problem.

[amitchandak]

@AdrianSantos___ , if you are using dataset, you can change column properties. You need to ask dataset owner.

The measure will not work in your case.

Check, are you allowed to change column property using column tools?

[AdrianSantos___]

No, there is no way to format any column. Is there no way to create any measure to yield a date field?
As @arock-well  mentions, a development to allow data formatting from a read-only dataset would be most helpful.  

[arock-well]

@amitchandak 

Are you aware of any future updates that will allow report developers to make custom measures in a report like @AdrianSantos___ is asking for without requiring the dataset owner make those changes to the original dataset? 

To me it doesn't make sense why the whole dataset needs to be updated for something very basic like this date formatting issue, especially if it's just a one-off update that a particular report is needing.