Technology, Analytics, DATA & Innovation
...por Anderson Oliveira
Thursday, July 9, 2020
Power Query - Rename Column by position
#"Renamed columns" = Table.RenameColumns(#"Promoted headers", {{Table.ColumnNames(#"Promoted headers"){0}, "Date_Price"}}),
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Power BI APP - Delete or Unpublish
UNPUBLISH DELETE
Power BI Service - Power Query - DataFormat.Error: Invalid cell value '#N/A'
There are two points to be evaluated: 1. If you want to discard the errors In this case, just run: #"Removed errors" = Table.Re...
Power Query - Read/Loader SharePoint.Files CSV , XLSX , JSON, XML, MySQL, Parquet, Azure Datalake & Azure Synapse
====================================================== CSV: let Source = SharePoint.Files("https://site", [ApiVersion = 15]), ...
Power Query M - Code for creating a table DCalendar (Fiscal)
Code for creating a table Dim_Calendar Refresh Path let Source = "C:\Temp\datasets\board\csv\__20200210_120926_.ARCHIVE" ...
No comments:
Post a Comment