Error updating data - API

[fehjacob]

I have a dashboard with an API connection, but the scheduled update is not working

something didn't work

Error processing data in dataset.
Try again later or contact support. If you contact support, please provide these details.
hide details
Data source errorThe credentials provided for the Web source are invalid The exception was raised by the IDbCommand interface. Table: bank-movement?startDate=2023-01-01&endDate=2024-12-31&selectionType=M.
Cluster URIWABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID553b8f6a-2483-4571-ba02-ef05431d6f3d
Request IDd086389b-9e2a-4a86-bb20-cb6f9789aa7d
Time2023-04-25 21:27:31Z

[fehjacob]

Have not been changed. I tried to access it through the browser and the username and password are working perfectly.

[collinq]

Hey @fehjacob ,

Has this ever worked or this is your first try?  If you are using the Gateway and/or the Service you may have to have some more items setup.  For example, you probably have to the Scopes and Service Principal working and setup first.  ( Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn) 

You probably don't have to have a gateway, but if you are using a Gateway, what userid is that using?

Also, is this your connection string in the API call?  "bank-movement?startDate=2023-01-01&endDate=2024-12-31&selectionType=M" ?  I am wondering if that is the right syntax for a Power BI API Call in the data connection?  Or if the preceding bit is correct?

[collinq]

Hi @fehjacob ,

Based on the error message, the userid and/or password that you are using are not valid for this data source.  If this worked in the past, has the userid or password changed recently?