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