Technology, Analytics, DATA & Innovation
...por Anderson Oliveira
Friday, June 5, 2020
Power Query - Dynamic & bulk change type
= Table.TransformColumnTypes(Source,List.Transform(List.RemoveFirstN(Table.ColumnNames(Source),2),each {_, type number}))
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