Forum Discussion
Semantic Model not updating/refreshing
I have a semantic model that is supposed to be pulling data from an excel file in onedrive for a dashboard. When i refresh the semantic model from my workspace in Fabric, it fails. However it refreshes normallly if accessed from powerbi desktop. I have tried updating the dataset credential but the connection test keeps failing with "The credentials provided for the Web source are invalid.".
There is no way to directly contact the fabric support Microsoft which is very appalling. Maybe because Fabric is free
Data source error: The credentials provided for the Web source are invalid. (Source at xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx). The exception was raised by the IDbCommand interface. Table: Request_Types.
Cluster URI: WABI-NORTH-EUROPE-I-PRIMARY-redirect.analysis.windows.net
Activity ID: 46ec304d-4fd5-46d5-bebc-7d7ab5fa7c93
Request ID: 5fc4b64f-c9f6-ddcb-0c09-e55568890d9d
Time: 2024-06-20 11:37:03Z
You are supposed to use the SharePoint Folders connector, not the web connector. The SharePoint Folders connector supports Oauth2
2 Replies
- lbendlin
Super User
You are supposed to use the SharePoint Folders connector, not the web connector. The SharePoint Folders connector supports Oauth2
It actually worked with the web connector to a onedrive location. The issue was the authentication. It works with Oauth2 and not basic authentication which I was using.
Thanks.
