Forum Discussion

vijaykaali811's avatar
vijaykaali811
Icon for Helper I rankHelper I
1 year ago
Solved

web data source not found in app.powerbi

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 ...
Show and Tell
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    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's avatar
    v-sgandrathi
    1 year ago

    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.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

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