web data source not found in app.powerbi

[vijaykaali811]

i  have power query from web url working fine in power bi desktop . but in app.powerbi. i can only see excel data source . there is no option to select web query . is it not available in app.powerbi online version 

[v-sgandrathi · Accepted solution]

Hi @vijaykaali811, 

What you're seeing is expected behavior,the Power BI Service (app.powerbi.com) allows only limited data sources like Excel or CSV when building reports directly online. The Web connector is not available in this environment. To use a Web URL, you’ll need to create the report in Power BI Desktop, where the Web data source is supported, and then publish it to the Power BI Service. Once published, you can configure refresh settings as needed. This is the recommended method for using web-based data in Power BI.

Thank you Community members for your involement.

Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!

Regards,

Sahasra.

[v-sgandrathi · Accepted solution]

Hi @vijaykaali811, 

What you're seeing is expected behavior,the Power BI Service (app.powerbi.com) allows only limited data sources like Excel or CSV when building reports directly online. The Web connector is not available in this environment. To use a Web URL, you’ll need to create the report in Power BI Desktop, where the Web data source is supported, and then publish it to the Power BI Service. Once published, you can configure refresh settings as needed. This is the recommended method for using web-based data in Power BI.

Thank you Community members for your involement.

Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!

Regards,

Sahasra.

[v-sgandrathi]

Hi @vijaykaali811,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @vijaykaali811,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-sgandrathi · Accepted solution]

Hi @vijaykaali811,

I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[rohit1991]

Hi @vijaykaali811 

You're correct. Once a report using a web data source is published to the service, Power BI can't refresh it unless you configure a gateway (usually a Personal Gateway) to handle the refresh from the local machine. 

This is because the Power BI Service does not natively support connecting to web URLs due to authentication and connectivity limitations in the cloud environment. To work around this, you'll need to either use a gateway to refresh the data in the service or consider exporting the web data to a supported source like SharePoint, OneDrive, or Azure, which can be accessed natively in the Power BI Service.

[Ritaf1983]

Hi @vijaykaali811 

This happens because Power BI Desktop is a development environment that supports many data sources, including Web URLs.
On the other hand, Power BI Service (app.powerbi.com) is meant for sharing and refreshing reports—not for creating new queries or connecting to new data sources directly.

That’s why you won’t find the Web connector option in the Service.
To use it:

1. Create the query in Power BI Desktop.

2. Publish the report to the Power BI Service.

3. Set up the data refresh, which is supported for Web sources as long as they were defined in Desktop.
   For more information please refer :
   https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources
   https://learn.microsoft.com/en-us/power-bi/connect-data/service-get-datahttps://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data

   If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[danextian]

Hi @vijaykaali811 

Is that a model created in Desktop and uploaded to the service or are you trying to create a report form scratch online? If the latter, only a few data sources are available