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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PetterR
Frequent Visitor

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

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:

Error_Message_OLEDB.png

The related query has this M-code:

Query.png

 

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

1 ACCEPTED SOLUTION
PetterR
Frequent Visitor

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.

View solution in original post

1 REPLY 1
PetterR
Frequent Visitor

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors