Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError joining SQL with Sharepoint Excel in PQ
The sources have been sucessfully loaded, joined (left outer)This. This right here. You should generally avoid merges, and you should especially avoid merges involving on-prem and cloud data sources. Because if you do you need to reconfigure your gateway to allow refresh of cloud data sources, and to add insult to injury you then also need to create a gateway connection for your cloud sharepoint (!!!) and you cannot get rid of that one once you went that route.
Don't do any merges in Power Query. Let the Vertipaq data model do the work for you.
The sources have been sucessfully loaded, joined (left outer)This. This right here. You should generally avoid merges, and you should especially avoid merges involving on-prem and cloud data sources. Because if you do you need to reconfigure your gateway to allow refresh of cloud data sources, and to add insult to injury you then also need to create a gateway connection for your cloud sharepoint (!!!) and you cannot get rid of that one once you went that route.
Don't do any merges in Power Query. Let the Vertipaq data model do the work for you.