Courses / Power Query (Get & Transform)
37. Credentials and Privacy Levels
How to manage data source credentials and privacy level settings that affect query access and combining data.
Power Query M
Credentials and Privacy Levels
Settings that control which credentials Power Query uses for each data source and how safe it must be when combining sources.
"I can access my company database, but Power Query refuses to merge it with my personal CSV — why?"
Credentials are the saved username/password or OAuth tokens Power Query uses to access a source; Privacy Levels (Public/Organizational/Private) tell Power Query how risky it is to share data between sources and whether combining them is allowed automatically.
"I can access my company database, but Power Query refuses to merge it with my personal CSV — why?"
Credentials are the saved username/password or OAuth tokens Power Query uses to access a source; Privacy Levels (Public/Organizational/Private) tell Power Query how risky it is to share data between sources and whether combining them is allowed automatically.