I set calculation mode to automatic but when I enter "=Now()" inside a cell I do not see the time updating even when formatting is changed to show seconds. Even setting the cell format to General does not change that. My problem is that even in Automatic calculation mode the cell does not automatically update which it should.This update makes it seamless for users to copy and paste their queries between Excel and Power BI Desktop.
These updates are available as part of an Office 365 subscription.
If you are an Office 365 subscriber, find out how to get these latest updates.
If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest We added a new Date/Time columns filter option in the Query Editor to allow users to filter by dates that are not the earliest or latest dates within the current column.
Another new Date/Time filter provides the ability to filter out values that are within the previous N minutes/hours/seconds. option under the Filter menu for Date/Time columns.
This is available as a radio button option at the bottom of the Credentials dialog.
It is now possible to add a prefix/suffix to an existing Text column via Query Editor—either by using this option under Transform (modify column in place) or under Add Column to create a new column (available under Text Column Format).They can then paste them into the Queries task pane in Query Editor for Power BI Desktop.Copying the queries from the Power BI Desktop into Excel is done in a similar way.In a day there are around 15,000 changes in prices of that particular security.The problem is that the RTD misses many prices when the market is fast and also it frequently (around 20 times per day) stops updating and then I have to clear the cell where the RTD is updated and it returns to normal, updating the prices for few minutes and then stop again.And yes, it did use up lots of resources but it did exist. Same with RTD server functionality, Microsoft had to post several fixes for that alone.