Hi there, there isn’t much difference between them in this example, but that was because I was using clean data from only two different sources. Power Query would be used if there were lots of different sources and the data needed to be transformed before it could be used e.g. remove empty rows, split text out etc then that could be loaded into the data model to be used in Power Pivot. Hope this helps.
Which version do you prefer? Power Pivot or Power Query?
Awesome! Power Pivot is a great tool
Thanks for sharing ❤
You’re welcome, hope it was useful 😀
Thanks for you video.. I was a little bit confused with the connection only and table option. Now you have made it very clear.
Awesome, glad it was useful.
Is there any reason why one method might be better than the other?
Hi there, there isn’t much difference between them in this example, but that was because I was using clean data from only two different sources. Power Query would be used if there were lots of different sources and the data needed to be transformed before it could be used e.g. remove empty rows, split text out etc then that could be loaded into the data model to be used in Power Pivot. Hope this helps.