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
Highlighted
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!


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?

Highlighted
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
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.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 21 members 756 guests
Please welcome our newest community members: