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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors