Forum Discussion

Khairin's avatar
Khairin
New Member
2 years ago
Solved

COULDN'T LOAD THE DATA FOR THIS VISUAL OLE DB or ODBC Error

Hye everyone, I'm receiving this error in my PowerBi 
"OLE DB or ODBC Error: OLEDB or ODBC error: A loop was found in the chain of Analysis Services data sources."

I'm uploading few semantic models into my powerBi to make an integrated powerBi Dashboard. Basically Im just pulling data from existing powerBi dashboard. when I first upload the data into my integrated dashboard they have no error. but when I closed my powerBi software and open the next day it popped up this message. 

 

How to resolve this issue. please help! thank you.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Khairin ,

    This error indicates that there is a circular dependency in the data model, first we can first check the relationship between the tables in the whole data model, if a table references itself directly or indirectly through other tables, a circular reference occurs.

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Khairin ,

    This error indicates that there is a circular dependency in the data model, first we can first check the relationship between the tables in the whole data model, if a table references itself directly or indirectly through other tables, a circular reference occurs.

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.