Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
59 | |
33 | |
27 | |
25 | |
24 |
User | Count |
---|---|
63 | |
53 | |
31 | |
24 | |
20 |