Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
We are using PBI Embedded with Service Principal auth. If we create a GW Datasource manually we get the option to set the "Connection string property" to "CustomData" rather than the default which is "EffectiveUserName". We need this for some reports that use CUSTOMDATA() in their DAX queries. I cannot find any way of setting this using the API - is it missing? We have code that successfully generates a new Gateway Datasource and permissions it with the SP but we cannot find any way to set the "Connection string property" to "CustomData" rather than the default which is "EffectiveUserName". In fact we cannot see the connection string at all through the API.
Hi, wondering if you ever found a way to change the PowerBI connectionstring to pass customdata.
Thanks.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.