Forum Discussion

jshutters's avatar
jshutters
Resolver I
7 years ago

Unable to refresh web data source in PBI Service

Hello, I'm unable to refresh a Web data source in PBI Service, which happens to be connected to an Excel file in SharePoint.    Error message is (from the Service, Dataset section)… "Your data sou...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi jshutters 

Is the credential used for sharepoint the same as which log in Power BI?

If so, use "Sharepoint online connnector" in Power BI Desktop to connect, after publishing to Service, edit credential (select "Oauth2") for the dataset.

You could follow this article.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jshutters's avatar
    jshutters
    Resolver I
    7 years ago

    Hi v-juanli-msft , Thanks for your insightful reply. While using a different connector looks like a work-around to avoid the web connector altogether, it certainly doesn't solve the issue why the web connector doesn't work, as I had described above. I'm starting to think that this might be a bug with the product.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Is your issue resolved? im ended up with the same problem