The Analyst Geektheanalystgeek.hashnode.dev·Aug 17, 2023Just Steps to Append and Merge data using Power Query in Power BIDifference between Append and Merge Merge queries can combine tables with different numbers of columns(it is simply a), while append queries require tables to have the same number of columns. Appending Files and tables in Power BI (Power Query) Appe...DiscussPowerBI
Kasturi Mukherjeekmukherjee.hashnode.dev·Jul 12, 2023Power Query in Power BI Desktop!!What is Power Query? Power Query is all about cleaning and analyzing the data. It is an ETL Service tool (Extract, Transform and Load). It allows you to import data from various sources which we call Extraction of the data and then we Transform (clea...DiscussPowerBI
Jimmy Mojimmoblog.hashnode.dev·Jun 30, 2023Power Query Dataflow - How to import Excel data into Dataverse from Power appsHave you ever been tasked with developing a canvas app that enables users to upload an Excel file and import its data into Dataverse? Even though it is a broad requirement but deal to some functional or licensing restriction in Power platform compone...Discuss·77 readspowerapps
Eniola Aboladeshocoleitt.hashnode.dev·Apr 1, 2023FIFA-21-data-cleaning with Power QuerySource Recently, I participated in a data cleaning challenge organized on Twitter, where I had the opportunity to use Power Query for the first time. I found the experience to be both fun and challenging, and it exposed me to the capabilities of this...Discuss·275 readsdata analysis
Stephen David-Williamsstephendavidwilliams.com·Mar 9, 2023Using Power Query to clean data in Power BIAlthough most of my data cleaning is conducted with Spark in Databricks, there are scenarios where my data doesn't need to undergo heavy transformations. If I can get my data to the output I need in just a few short steps, why not do that? In this bl...Discuss·1 like·82 readsPowerBI
Viraj Rathnayakavirajr.hashnode.dev·Feb 14, 2023Leading Zero in a month number in Power QueryNo one, absolutely no one wants to work with dates in Power Query/DAX/Power BI. But we can't avoid the date/DateTime data type as most fact tables are recorded around time and/or date. It was another day and another power query project (not a data an...Discuss·30 readsPowerBI
