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.

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

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.