Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Can I change the data source connection type for a dataflow?

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?

RachelH724_0-1632355034804.png

 

1 ACCEPTED SOLUTION

@Anonymous No, open Settings for the dataflow and there you can edit the Data source settings.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

@Anonymous Go to File | Options and settings | Data source settings. Choose the data source and then Edit Permissions...



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@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?

RachelH724_1-1632410476040.png

 

@Anonymous No, open Settings for the dataflow and there you can edit the Data source settings.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

carerix_0-1675367620255.png

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

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors