Forum Discussion
Importing data - Which method will refresh my data quicker??
Hello all, I've got a doubt, probably the answer is simple but I'm not sure about it. I am looking to load/refresh my data in the quickest way possible. I have written a large sript in SQL th...
ManuApo The fastest way should be to use SQL to create a view and then just select that view in Power Query. But I'm confused as to when you have 1 table and when you have 3.
Lets say I dont want to start creating views yet. This script I have is actually a stored procedure that produces multiple tables. From those tables I am interested to extract into Power BI 3 of them.
My question is if I should append these 3 tables into one table to just query the database one time and then separate the 3 tables in power query. Or query 3 times to the database using the same script except the last select statement which will extract each time one different table.
Hope that is more clear
