Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |