Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now

fbcideas_migusr

Do not require credentials to be entered for Anonymous web data sources

Submitted by on ‎03-03-2016 08:09 PM
For data sources which are anonymous web endpoints, it seems a bit silly that I have to go click through "enter credentials" every time I upload my PBIX. They are anonymous - it should work on its own, or at least try rather than failing to refresh the datasource due to missing credentials.
Status: Declined

The security model that we use requires a connection to be create for all the sources that are in your Mashup script. This also means that privacy levels need to be taken into consideration which could impact how data moves between your Anonymous sources and other perhaps sources that should not be sent to that source or others.

I understand from previous comments that perhaps the scenario is more related to using OAuth. You are able to use custom OAuth flows with the Power Query SDK and leverage your own custom connector. You can learn more about this capability from the link below:
Develop a connector using the Power Query SDK - Power Query | Microsoft Learn 

See more ideas labeled with:
3 Comments (3 New)
Comments
angryanalytics
New Member
‎07-05-2020 03:20 PM
My votes for this item is because we also have to use Anonymous when trying to broker an OAuth flow. Because the OAuth flow is not supported natively, we have to use M Script to pass creds to an authorization service using "Web.Contents" and then pass that token retrieved to the next "Web.Contents" call to get the result. The PowerBI service should act as the power bi desktop and allow the flow to occur instead of statically checking for a valid 200 response. It would also work to allow an "override" option to say "yes, I know this is returning a 403/404 but trust me, I know what I am doing".
fbcideas_migusr
New Member
‎02-24-2025 08:52 AM
Status changed to: Needs Votes
 
miguel
Community Admin
Community Admin
‎07-15-2025 10:33 PM
Status changed to: Declined

The security model that we use requires a connection to be create for all the sources that are in your Mashup script. This also means that privacy levels need to be taken into consideration which could impact how data moves between your Anonymous sources and other perhaps sources that should not be sent to that source or others.

I understand from previous comments that perhaps the scenario is more related to using OAuth. You are able to use custom OAuth flows with the Power Query SDK and leverage your own custom connector. You can learn more about this capability from the link below:
Develop a connector using the Power Query SDK - Power Query | Microsoft Learn