Forum Discussion
Error loading into model, Black Bar in model view
Hi MM1001,
I tried to reproduce the issue as described. I created a new table with a single column named Text_ID containing sample text values like “N089030”, “N089045”, etc.
The data was either entered manually or loaded through Power Query, and the column type remained as text. There were no errors in the query, and after clicking Close & Apply, the data loaded successfully without any issues.
The table appeared properly in Data View, and there were no red error indicators or failed load messages. In the Model View, the table was visible without any relationships, as I didn’t create or connect it to any other table.
This confirms that a basic, single-column text table loads fine in Power BI under normal conditions. If you're still facing the black bar issue or model load error, it could be due to auto-relationship detection, a background model corruption, or a version-specific bug.
You might want to disable auto-detect relationships in File > Options > Data Load or try loading the same data in a fresh PBIX file to test further.
Please find the attached pbix file for youe reference.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Tejaswi.
Community Support Team.
No relationships are connected to this data
Hi MM1001,
I tried to reproduce the issue as described. I created a new table with a single column named Text_ID containing sample text values like “N089030”, “N089045”, etc.
The data was either entered manually or loaded through Power Query, and the column type remained as text. There were no errors in the query, and after clicking Close & Apply, the data loaded successfully without any issues.
The table appeared properly in Data View, and there were no red error indicators or failed load messages. In the Model View, the table was visible without any relationships, as I didn’t create or connect it to any other table.
This confirms that a basic, single-column text table loads fine in Power BI under normal conditions. If you're still facing the black bar issue or model load error, it could be due to auto-relationship detection, a background model corruption, or a version-specific bug.
You might want to disable auto-detect relationships in File > Options > Data Load or try loading the same data in a fresh PBIX file to test further.
Please find the attached pbix file for youe reference.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Tejaswi.
Community Support Team.
Hi MM1001,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Tejaswi.
Hi MM1001,
Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.
Please don’t forget to “Accept as Solution” and Give “Kudos” if the response was helpful.
Thank you.
Tejaswi.
Hi MM1001 ,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.
Thank you.
Hi there!
After some further testing, I’ve noticed a consistent issue. When I create a Power BI report from scratch in the desktop app and add new schemas, everything works perfectly — relationships are detected, and data loads as expected.
However, when I download an existing report (either from the Power BI Service or from a restored file), the Auto Detect Relationships feature seems to break. Even if the new schema doesn’t contain any detectable relationships, the data fails to load properly, and I get a dataset with the black highlight I mentioned earlier.
Interestingly, if I disable Auto Detect Relationships in these downloaded reports, I’m then able to add new schemas without any issues.
Thanks again for your help!
— Matt