Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
fhovey
Frequent Visitor

Quickbooks Online credentials

I'm logged into quickbooks online on Power BI desktop just fine and everything refreshes. I published it to my workspace and went to set an autorefresh and it asked me to log into QBO. I logged in but then I get this error message. It's the same credentials from the desktop. Does anyone know how to fix this? Thanks!

 

Failed to update data source credentials: ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failedHide details

Activity ID:1c8e67db-60c0-4056-90f5-3efe6e5afa5c
Request ID:4601c7a8-e9be-cec4-4eb5-36e26c348c64
Status code:400
Time:Fri Mar 01 2024 17:46:48 GMT-0500 (Eastern Standard Time)
Service version:13.0.22729.74
Client version:2402.3.18145-train
Cluster URI:https://wabi-us-north-central-b-redirect.analysis.windows.net/
22 REPLIES 22

Hi @fhovey ,

 

The 400 error code indicates that the data source credentials are incorrect.

 

Can you make sure that under the dataset settings you have updated the credentials to the correct location?

 

Maybe you can use OAuth2 authentication instead of basic authentication.

 

These two cases may be helpful to your problem.

Solved: Refresh failed - Status code 400 - Microsoft Fabric Community

Solved: Status code 400 - Microsoft Fabric Community

 

If you have any further questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

It doesn't give me the option to select basic auth

fhovey_0-1710249296115.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors