Forum Discussion
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?
Anonymous No, open Settings for the dataflow and there you can edit the Data source settings.
4 Replies
- Greg_Deckler
Community Champion
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?
- Greg_Deckler
Anonymous No, open Settings for the dataflow and there you can edit the Data source settings.