Create connection only in Power BI Desktop

Posts: 4
Joined: Mon Jul 24, 2017 7:58 pm

Create connection only in Power BI Desktop

Postby Peter079 » Mon Jul 23, 2018 10:28 pm

Hi, I have used Power Query in Excel and make use of the only create connection followed by an append to create the table that I want.

Is it possible to do the same thing (only create connection) in Power BI Desktop ? I can't find a create connection function.

If not presumably it can still be achieved by importing the data into Power Query for Excel and carrying out the append query in Power Query, and then uploading the data into Power BI, and if so, will refresh still work and presumably I can refresh the data in Power BI Desktop.

Many Thanks for taking the time to read and reply


Posts: 1019
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Create connection only in Power BI Desktop

Postby MattAllington » Thu Jul 26, 2018 7:10 am

Yes you can do it. Create the query first. When it is created, while still in the query editor, right click on the query on the left of the screen and "uncheck" enable load.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest