Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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".
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
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,
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
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.
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
Please change to Date, not to DateTime.
How would I do this?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
32 | |
16 | |
12 | |
10 | |
9 |
User | Count |
---|---|
44 | |
24 | |
20 | |
14 | |
13 |