3 posts • Page 1 of 1
- connect to the source data
- set this query so it doesn't load. In PBI, right click and turn off "enable load". In Excel, "close and load", "Connection only"
- go back into power query, right click on the above query, select "reference"
- build table 1
- repeat the 2 steps above for each additional table
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
Who is online
Users browsing this forum: No registered users and 4 guests