Forum Discussion
Data model shows red border
Hi all
I'm not sure why the tables in my data model are shown red. The storage mode is DirectQuery and I'm working on a dataset.
Everything is working fine, and I can also modify relationships between the tables - but it's irritating, that it's not shown as usual in blue.
Has anything like this already appeared to anyone?
Hi PRV ,
Please check the following -> https://community.fabric.microsoft.com/t5/Desktop/Red-bar-on-Direct-Query-Model-View/td-p/4176443In Syntesis, you may have errors within your queries or sources.
Did I answer your question? Mark my post as a solution!
MattiaFratello - Just beat me to it!
PRV - The answer from the link above you need is as follows:
"The red bar in Power BI's Model view, which typically indicates something unusual, signifies that the direct query source in your mixed storage mode is not functioning correctly.The direct query connection to the external semantic model or database might be broken. This could be due to network issues, incorrect credentials, or access rights. Check if the source is online and that your credentials are still valid.Go to the Data Source Settings and verify the connection to the external source.Go to the Error Pane (usually under the "Model" or "Data" tab) to see if there are any specific errors or warnings related to your DirectQuery source.If there have been changes in the underlying data source, such as modifications to tables, columns, or data types, this could cause the red bar.
if we can address the above issues, hopefully the Red bars should turn into blue color. please check the above points and fix items."
4 Replies
Hi PRV ,
Please check the following -> https://community.fabric.microsoft.com/t5/Desktop/Red-bar-on-Direct-Query-Model-View/td-p/4176443In Syntesis, you may have errors within your queries or sources.
Did I answer your question? Mark my post as a solution!
MattiaFratello - Just beat me to it!
PRV - The answer from the link above you need is as follows:
"The red bar in Power BI's Model view, which typically indicates something unusual, signifies that the direct query source in your mixed storage mode is not functioning correctly.The direct query connection to the external semantic model or database might be broken. This could be due to network issues, incorrect credentials, or access rights. Check if the source is online and that your credentials are still valid.Go to the Data Source Settings and verify the connection to the external source.Go to the Error Pane (usually under the "Model" or "Data" tab) to see if there are any specific errors or warnings related to your DirectQuery source.If there have been changes in the underlying data source, such as modifications to tables, columns, or data types, this could cause the red bar.
if we can address the above issues, hopefully the Red bars should turn into blue color. please check the above points and fix items."
PRV - Direct query would normally have a dark blue border to show separate it from import or dual tables, but as you have enabled dark mode, I guess this turns to red for added visibility.
Try switching back from dark mode and see if the bars turn blue.
If this helps, please accept as the solution, it will help others with the same query.
mark_endicott It's still in red. In other datasets it's shown in blue aswell, even if I have it in dark mode.
