A quick post today about Last refresh Data/Time on a Power BI Service. The Last Refresh Date/Time alerts users how new the data is for the report. You can visualize the Last refresh Date/Time with a card that shows the date and time that the data for the report was last updated. On Power BI Desktop and Power BI Report Server, you can use DateTime.LocalNow() to get the Last refresh Date/Time for a report. When you publish the same report…
In this post, we will discuss how to convert Hours into Minutes and add it to the existing Minutes to get a whole number. I tried two different methods and got the same result, so I decided to share it with you. Let’s walkthrough the steps: I have a simple table with a Ticket and Time columns. I need to convert the Hours to Minutes and add it to the existing Minutes in the Time column to get a whole…
Just like any other language, Power Query has its own different types of errors, one of them is DataFormat Error. Dataformat errors in Power Query are mostly data type errors and do not prevent you from loading data to Power BI, instead the cells will be loaded as blank. The screenshot below shows 3 errors for 78 records when the data is loaded to Power BI. To audit the error or get more details, do the following: Click on View…