cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALEX13 Regular Visitor
Regular Visitor

Problem in changing de data source

Hi community, I have the following problem when trying to change de data source of the tables in my power bi report:

 

Captura.PNG

 

It is impossible to apply changes, as I always get the same error message,

When the change is made file by file, no error appears.

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Problem in changing de data source

Take a look at this thread:

 

https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/td-p/116683

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


3 REPLIES 3
Super User
Super User

Re: Problem in changing de data source

Apparently when you changed sources you have duplicate values in your CUPS column whereas you didn't before. So, you need to remove the relationship to get your data to load. You will likely need a new table that has unique CUPS that you can use as a bridge table.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
ALEX13 Regular Visitor
Regular Visitor

Re: Problem in changing de data source

Hi Greg, ¿what about the OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. error?

Super User
Super User

Re: Problem in changing de data source

Take a look at this thread:

 

https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/td-p/116683

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 59 members 1,385 guests
Please welcome our newest community members: