Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Has this been published yet? If not, does anyone know when it will be published?
Solved! Go to Solution.
Hi @Anonymous,
Power BI desktop August 2017 update has been released. You can view the August feature summary and download the file from below blog:
Power BI Desktop August Feature Summary
Best regards,
Yuliana Gu
Hi all, I have updated PowerBI desktop last night. I have a script I'm reusing every month to read multiple excel files from a folder and apply some transformations on the data, sicne I have updated to the august version I keep on getting this error:
Expression.Error: The column 'Day' of the table wasn't found.
Details:
Day
Also when got back to read the script from the reports produced in a previous month I got the same error again! although it was working perfectly before the update!!!
I looked for solutions in the community but none applies to this!!
Help please!!
Here's the full script:
let
ImportDaily =
let
Source = Folder.Files(<Folder Path>),
#"Removed Other Columns" = Table.SelectColumns(Source,{"Content"}),
#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "GetExcelData", each Excel.Workbook([Content])),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Content"}),
#"Expanded GetExcelData" = Table.ExpandTableColumn(#"Removed Columns", "GetExcelData", {"Name", "Data", "Item", "Kind", "Hidden"}, {"Name", "Data", "Item", "Kind", "Hidden"}),
#"Removed Columns1" = Table.RemoveColumns(#"Expanded GetExcelData",{"Hidden"}),
#"Added Custom1" = Table.AddColumn(#"Removed Columns1", "RemovedRows", each Table.Skip([Data],5)),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "PromotedHeaders", each Table.PromoteHeaders([RemovedRows])),
#"Added Custom3" = Table.AddColumn(#"Added Custom2", "DateFill", each Table.FillDown([PromotedHeaders],{"Day"})),
#"Added Custom4" = Table.AddColumn(#"Added Custom3", "RemoveChannel", each Table.RemoveColumns([DateFill],{"Channel"})),
#"Added Custom5" = Table.AddColumn(#"Added Custom4", "RemoveFileName", each Table.RemoveColumns([RemoveChannel],1)),
#"Removed Columns2" = Table.RemoveColumns(#"Added Custom5",{"RemoveFileName"}),
#"Added Custom6" = Table.AddColumn(#"Removed Columns2", "UnpivotData", each Table.UnpivotOtherColumns([RemoveChannel], {"Start GP", "Day"}, "Attribute", "Value")),
#"Removed Other Columns1" = Table.SelectColumns(#"Added Custom6",{"UnpivotData"}),
#"Expanded UnpivotData" = Table.ExpandTableColumn(#"Removed Other Columns1", "UnpivotData", {"Day", "Start GP", "Attribute", "Value"}, {"Day", "Start GP", "Attribute", "Value"})
in
#"Expanded UnpivotData",
#"Filtered Rows" = Table.SelectRows(ImportDaily, each ([Day] <> "Total")),
#"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Day", type date}, {"Start GP", type time}, {"Attribute", type text}, {"Value", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","--","",Replacer.ReplaceText,{"Value"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value",{{"Value", type number}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Start GP", "5min"}, {"Attribute", "Channel"}, {"Value", "000s"}}),
#"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns",{"Day", "Channel", "5min", "000s"}),
#"Renamed Columns1" = Table.RenameColumns(#"Reordered Columns",{{"Day", "Date"}}),
#"Filtered Rows1" = Table.SelectRows(#"Renamed Columns1", each ([000s] <> null))
in
#"Filtered Rows1"
Thank you !
Just downloaded it. Great features, but I am missing the marker option for line graphs.
Hi @Anonymous,
Power BI desktop August 2017 update has been released. You can view the August feature summary and download the file from below blog:
Power BI Desktop August Feature Summary
Best regards,
Yuliana Gu
Hey,
on this blog post
https://powerbi.microsoft.com/en-us/blog/here-s-how-microsoft-executives-are-using-power-bi/
, down in the comments it is stated, that the August update will be released any time soon, personally I guess today or tomorrow at the latest.
Regards
The reason I asked is because a couple of months ago (I think it was the June update) - the program was updated, but the desktop version did not let you know. So I just wanted to be sure I didn't miss it.
I think it was in July when the program did not notify about the update. I only found out about it from Power BI blog.
Proud to be a Super User!
If you turn on Updates under File|Options, the PowerBI Desktop should automatically inform you that an update is available when a new one has been released. It's been working ok for me since they introduced the feature:
There's an "yet to be announced" August 2017 version: https://www.microsoft.com/en-us/download/details.aspx?id=45331
Downloading now. 🙂
Sorry for false alarm... downloaded file same as July.
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |