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 source can't be refreshed because the credentials are invalid. Please update your credentials and try again." See screen shot below.
When I look at my dataset settings in the Service, I have 2 data sources…
One source to Teradata DB on-prem, which connects fine when the data gateway is on and running. No problem there.
The other source is using the Web connector option to an Excel file on SharePoint. When I click on the "Edit credentials" in the above screen shot, I see only 3 choices for the authentication type. Where is the Organizational Type method?
In summary, I'm confused why the PBI Service doesn't offer an "Organizational account" authentication method and doesn't let the Web connector refresh, when I see the option in the Desktop and can refresh there.
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.