Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors