OLE DB or ODBC-Error when changing datasource from TEST to PROD

[PetterR]

Dear all,

we have a Project Online scenario with Power BI reporting with a TEST and PROD stage. Usually report are developped against the TEST instance of Project Online and only for UAT the new report is connected (via parametrized URL) to the PROD system.

Recently I experienced the issue, that a report smoothly running against TEST or PROD instance of Project Online database cannot be switched anymore. In particular chaning the parametrized URL from *pwa-test* to *pwa* (or vice versa) in Power Query allows for refreshing all queries, however when applying the changes in PBI Desktopclient and refreshing the queries there I get the following error message with one of the queries:

The related query has this M-code:

What i did so far was removing all global and query specific credentials and resetted them, also cleared cache, but to no avail.

Any idea how to proceed here?

Kind regards

Petter

[PetterR · Accepted solution]

Issue could be solved, based on information from older post by Ben Howard: the table from Project Online imported in this query was too "broad", therefor we added a Power Query step immediately after source to remove unnecessary columns and issue disappeared.