Basic and advanced options not showing on Get data Web window

Amy Squire 20 Reputation points
2026-09-04T12:31:48.19+00:00

Hi, I am trying to use an API with Power BI. My colleagues and I currently have the free version 2.157.879.0 64-bit (August 2026). Despite us all having the same version, when I click Get Data and select Web, I do not get the same Basic and Advanced options that my colleagues do. I only get the below window and so there is nowhere to add the API key. When I put in the URL of the query I want, I get an "invalid credentials" error. Why am I not seeing the same options and how to I get the Advanced option please?

User's image

Many thanks

Amy

Microsoft 365 and Office | Excel | For business | Windows
0 comments
Answer accepted by question author
Daniel-Vo 6,355 Reputation points Microsoft External Staff Moderator
2026-09-04T13:34:07.3366667+00:00

Hi Amy,

If you and your colleagues are running the same Power BI Desktop version but only your Web connector is missing the Basic and Advanced options, this is typically related to local Power BI configuration rather than the version itself. The screenshot in your post suggests that you are seeing a different Web connector experience than the traditional dialog.

I would recommend the following checks:

  1. Compare Preview Features
    • Go to File > Options and settings > Options > Preview features.
    • Compare your settings with a colleague who can see the Basic/Advanced tabs.
    • Restart Power BI after making any changes.
  2. Clear Existing Credentials
    • Go to File > Options and settings > Data source settings.
    • Remove any stored credentials related to the API endpoint.
    • Try connecting again.
  3. Use Power Query as a Workaround If you need to send an API key or authorization header, you can bypass the Web dialog entirely by using Power Query (Advanced Editor)
  4. Download the latest Power BI desktop version at: Download Microsoft Power BI Desktop from Official Microsoft Download Center

User's image

To help identify the root cause, could you also confirm:

  • Whether you are using the Microsoft Store version or the downloadable MSI version of Power BI Desktop?
  • What type of authentication the API requires (API Key, Bearer Token, Basic Auth, etc.)?
  • Whether your colleagues are using exactly the same installation type?

Was this answer helpful?

2 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.