Forum Discussion
Power Query Load fails after "Detecting relationships"
Hello Community, I've searched multiple sources but cannot find the problem here.
I have a pbi file already done, published and shared, all ok. The main source of data is a Databricks connector.
Im trying to add a new query from the same source and using the same Databricks connector and credentials, all is exactly the same, just a different table. I can extract and see all the data but when I tried to load them into my report it fails with the "An error occurred while loading to the model.". The error happens everytime after a "Detecting relationships" status in the loading process.
If I tried to add the same query in a new blank file, it goes ok without issues. I've tried several ways without success. Clean PBI cache and no change.
And after this screen I get:
Does anyone has any suggestions? I cannot see anything wrong with my table, I have tried changing the names of the file and columns, but no change.
Thank for your help!
An error at the "Detecting relationships" step is almost always auto-detect choking on the new table, usually because a column name matches an existing one but with mismatched types or unexpected nulls, so the auto-relationship logic crashes the load. The fact that loading the same query into a blank file works lines up with that.
The quickest workaround is to disable auto-detect before loading: File > Options and settings > Options > Current File > Data Load, uncheck "Autodetect new relationships after data is loaded". Then load the table and create any relationships you need manually in Model view.
If this worked for you, kindly mark it as the solution and give a thumbs up.
Thanks,
Shai Karmani
1 Reply
- Shai_Karmani
Super User
An error at the "Detecting relationships" step is almost always auto-detect choking on the new table, usually because a column name matches an existing one but with mismatched types or unexpected nulls, so the auto-relationship logic crashes the load. The fact that loading the same query into a blank file works lines up with that.
The quickest workaround is to disable auto-detect before loading: File > Options and settings > Options > Current File > Data Load, uncheck "Autodetect new relationships after data is loaded". Then load the table and create any relationships you need manually in Model view.
If this worked for you, kindly mark it as the solution and give a thumbs up.
Thanks,
Shai Karmani