cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anadavalos
Frequent Visitor

ODBC data sources connecting to AS400 - Sudden failures after working for a long time.

Data source error:{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [42000] [IBM][System i

This is the error. I get.

 

 

 

Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token . was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT ORDER UNION EXCEPT OFFSET."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=CAMBRO400"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: DimItemMaster.Cluster URI:WABI-WEST-US-redirect.analysis.windows.netActivity ID:4242297b-6b3f-4f20-8d4c-14c20c5ce63cRequest ID:c67429c9-0f33-4372-84e3-99908f4401c3Time:2020-07-02 12:45:45Z

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@anadavalos ,

 

Have you installed the latest ODBC driver for your data source? Please refer to: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-using-generic-interfaces#data... 

Also make sure the credentials you input in power bi service is valid.

 

Regards,

Jimmy Tao

View solution in original post

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

@anadavalos ,

 

Have you installed the latest ODBC driver for your data source? Please refer to: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-using-generic-interfaces#data... 

Also make sure the credentials you input in power bi service is valid.

 

Regards,

Jimmy Tao

Anonymous
Not applicable

Hi @anadavalos 

 

Go to right top corner, there you will get 3 dots, then choose "Setting -> Manage Gateway".

 

There, please re-enter the DB credentials.

 

Kind Regards

Ashwani

anadavalos
Frequent Visitor

Hello @Anonymous 

I am signed in to PBI service but with so many hidden pages. How do I sined in to Gateway. I am scheduling the refresh from scratch so I must be signed in.?

 

Thanks

Anonymous
Not applicable

Hi @anadavalos 

 

I also faced this issue. And resolved by re-enter DB UserID & DB pwd in Gateway.

 

Kind Regards

Ashwani

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.