Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
The security model that we use requires a connection to be create for all the sources that are in your Mashup script. This also means that privacy levels need to be taken into consideration which could impact how data moves between your Anonymous sources and other perhaps sources that should not be sent to that source or others.
I understand from previous comments that perhaps the scenario is more related to using OAuth. You are able to use custom OAuth flows with the Power Query SDK and leverage your own custom connector. You can learn more about this capability from the link below:
Develop a connector using the Power Query SDK - Power Query | Microsoft Learn