Join 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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I inherited a Power BI dataset that is created via dataflow that calls an API. My colleague left and I'm having trouble updating my credentials. I've submitted a service ticket to the API's company, and then stumbled into the power query editor in the web service after clicking 'edit' on an entity in the dataset. I was asked how to connect to each entity and selected anonymous (which is how the API works with Power BI for us) and my tables loaded. However, for one table/entity, I selected basic and now I get this error:
"Expression.Error: The 'US-Customer-Api-Key' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer"
Is there a way I can change the data source type back to anonymous?
Solved! Go to Solution.
@Anonymous No, open Settings for the dataflow and there you can edit the Data source settings.
@Anonymous Go to File | Options and settings | Data source settings. Choose the data source and then Edit Permissions...
@Greg_Deckler - In the service-based query editor, there's no 'File' option in the menu (see screenshot). Would I need to change it in the desktop file, which is connected to the dataflow?
@Anonymous No, open Settings for the dataflow and there you can edit the Data source settings.
Hi Greg_Deckler,
I which part of the Power Query menu in Power BI Service can I find the option "Settings"?
Could you send me a screenshot to help me?
Best regards Louis