Power Query Convert Columns to Rows for groups and expand columns dynamically in 2 ways
More Information below This Power Query challenge uses GroupBy, List functions and a little hack There's also a trap with ...
The best way to connect to a SharePoint Folder to speed up your Excel and Power BI data refresh
Learning Power BI? Check out my course https://accessanalytic.thinkific.com/ How to consolidate multiple files from a SharePoint ...
How to connect to an Excel or CSV File on SharePoint / OneDrive using Power Query
The quickest way to use Power Query to connect to an Excel or CSV file on SharePoint / OneDrive The team and I at Access ...
10 Million Rows of Data Loaded into Excel ( **see updated version of this - link in description**)
NOTE! Newer Version of this video is now here https://youtu.be/Od9ev90PB1w If a member of your team or organisation says that ...
Magically Fixing Big Slow Excel files with a single click
The Inquire add in can fix large slow Excel workbooks with a single click ...
How to use Power Query to connect to a file on OneDrive or SharePoint (⚠️ see update in links below)
READ THIS UPDATE from MAY 2021 I've a quicker technique for the From Web Method now Check it ...
Extract Power BI data & measures with Power Automate
How to use Power Automate to extract Data from Power BI and create a CSV file on SharePoint AND how to update an Excel table ...
3 Essential Excel skills for the data analyst
Learning Power BI? Check out my course https://accessanalytic.thinkific.com/ This is my opinion on the 3 key Excel skills a data ...
Why Access Analytic for your Power BI Training
PDF: ...
How to use Power Query to Combine Multiple Files that have different headings
When using Power Query to Combine Files from a folder there is a problem that only the 1st file's headings are used in the output.
Access Analytic
@AccessAnalytic
13125
Stats
34439
Rank
13.1K
Points
10
Videos
5
Articles
0
Reviews
0
Comments