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

[Sonyat810]

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

[lbendlin]

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

[Sonyat810]

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]

[Sonyat810]

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

[jbwtp]

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

[Sonyat810]

This is whatI have

[lbendlin]

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.

[Sonyat810]

Can you walk me through this?

[lbendlin · 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".

[Sonyat810]

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]

So add a new column with [Date]?

[lbendlin]

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

[lbendlin]

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

[Sonyat810]

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

[lbendlin]

Please change to Date, not to DateTime.

[Sonyat810]

How would I do this?