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
Sonyat810
Helper I
Helper I

Power BI will not take time from power apps and my excel sheet only shows dates currently.

I am using power apps to update my report in power bi, but it keeps giving me the time and wont update the report with this. How can I get around this

1 ACCEPTED SOLUTION

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtY3MtI3MjAyUjA0sjIwACIFR1+l2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type datetime}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type date}})
in
    #"Changed Type1"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".

View solution in original post

16 REPLIES 16
lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

I have an excel sheet that feeds power bi, my manager wants power apps as a user interface to enter data into the excel sheet, but its entring hours and minutes and power bi dont seem to take that

Sonyat810_0-1662980060262.png

 

How can I allow or prevent Date and hours to be included and updated in my report. The current report have all time as 12:00 am but only updates the datein Power bi, once I added power apps it updates my excel sheet that feeds piwer bi with a date and time. Power Bi isn;t updating the data

Hi Sonya,

@Sonyat810 ,

 

From what I could get from your posts you may have a step called Changed Type in your query, which may contain something like this code:

= Table.TransformColumnTypes(PreviousStep,{{"DateTimeField", type date}})

This truncates your datetime data to date only. Try changing it to something like this (i.e. datetime instead of date😞

= Table.TransformColumnTypes(PreviousStep,{{"DateTimeField", type datetime}})

 and see if this helps.

 

Cheers,

John

This is whatI have

 

Sonyat810_0-1663064265852.png

 

Now add a new step that transforms the [Date]  column to type date.  Make sure to add a new step, not replace the existing step.

Can you walk me through this?

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtY3MtI3MjAyUjA0sjIwACIFR1+l2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type datetime}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type date}})
in
    #"Changed Type1"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".

I'm sorry. I'm trying to understand what you are asking me to do. Do I do this on Add Column or Transform tab. This is what I currently have, but when a new record is recorded it has the time and wont update.

Sonyat810_0-1663090317396.png

 

So add a new column with [Date]?

Not required - add another data type change step to the existing column.

In Power Query you can accept the source data as datetime and then convert the column to date format.

I changed my source date to time, but only the ones you see with 00 time gets updated in power BI 

Sonyat810_0-1663087982029.png

 

Please change to Date, not to DateTime.

How would I do this?

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