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.
There is only one column and it is text, my main struggle is that there are no errors in any of the queries before I press Close and Apply
Then it loads, shows me the rows, Detects relationships and then give me the error message
Resolver IIIIs it 1-1 relationship it shows you may have 13 values repeated atleast once as per distict and unique count.
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.