This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. 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