Power Query

Data Setup Everything you need to know about structuring your data when completing Power BI reports M Code Showcase Ask questions and share knowledge about Power BI Showcase related to M Code

Topic	Replies	Views	Activity
About the Power Query category Power Query	1	1928	November 12, 2019
Enterprise Calendar Power Query	0	5	July 1, 2024
Power Query performance when parsing JSON records Data Setup	0	21	July 1, 2024
Query references other queries, so it may not directly access a data source Error experienced by other users Power Query	8	70	July 1, 2024
Primary key ID column Power Query	9	80	July 1, 2024
Best practice to achieve tabular model from financial report layout Data Setup	2	155	June 26, 2024
Why is Power query transform data and the close and load not in the same order? Power Query	4	192	June 18, 2024
No Power BI dataset connector for thin report? Power Query	5	204	June 11, 2024
M-Code Running Totals Data Setup	2	142	June 4, 2024
Power Query Data Cleaning Power Query	2	196	May 23, 2024
M Code to paginate not working in Service Power Query	1	183	May 23, 2024
Weekly Updates - Net New + Existing Records Data Setup	1	196	May 23, 2024
Dynamic data source won't save in Power BI Service Power Query	1	190	May 23, 2024
Extended Date Table Fix M Code Showcase	2	416	May 4, 2024
Creating a custom function to extract data from folder based on extension Power Query	2	286	April 24, 2024
Power Query and access to a folder with lots of pasword protected xlsx files Power Query	1	205	April 22, 2024
Table Transformation - Column to rows ( Split Columns & append) M Code Showcase	5	311	April 22, 2024
Query to join sheets when the path to the file is on a network drive M Code Showcase	7	403	April 18, 2024
How to Make DateEnd parameter equal today Power Query	5	362	April 18, 2024
Connecting to API with access token Power Query	3	505	April 15, 2024
Help with "if column values do not match another column values then..." Power Query	4	256	April 11, 2024
New book: The Definitive Guide to Power Query (M) M Code Showcase	10	1092	April 8, 2024
Collecting Addresses from disorganised spreadsheets into one Data Setup	1	319	March 28, 2024
DataSource.Error Power Query	1	348	March 25, 2024
Dynamic 13 Period Calendar M Code Showcase	6	395	March 23, 2024
Query for a folder results in a null Power Query	1	294	March 13, 2024
EDNA Date table - Half Years, Fiscal Years, suffixes and prefixes Data Setup	1	400	March 1, 2024
Handling multiple tables on 1 sheet Power Query	5	465	February 28, 2024
13 Period Fiscal Calendar (Power Query M function) M Code Showcase	7	3491	February 26, 2024
Merge dates across quantity and text flag Power Query	2	374	February 24, 2024