Forum Discussion

PRV's avatar
PRV
Frequent Visitor
1 year ago
Solved

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...
  • mark_endicott's avatar
    mark_endicott
    1 year ago

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