please help

[SherifHassan]

Hi Dear,

i have this issue when i open my power bi desktop for 2 projects only

[SherifHassan]

Please advise , what I can do ?

[Elena_Kalina]

1. First Indicators

• Open your PBIX file and look for:

  • Yellow warning triangles in the Fields pane

  • "Refresh error" notifications with object names

  • Greyed-out measures/columns

2. Power Query Investigation

1. Go to Transform data → Data source settings

2. Click "Edit Permissions" and look for red error indicators

3. Check each query in Power Query Editor for:

   • Source steps showing errors

   • Removed columns (will show as "Invalid")

3. Advanced Detection Methods

// Paste this in Advanced Editor to find broken dependencies
let 
    AllQueries = #shared,
    QueryList = Record.ToTable(AllQueries),
    StatusCheck = Table.AddColumn(QueryList, "Status", each 
        if Value.Is([Value], type table) then 
            try Table.RowCount([Value]) otherwise "BROKEN" 
        else "Not a table")
in
    Table.SelectRows(StatusCheck, each [Status] = "BROKEN")

4. For SSAS/Tabular Models

• Use SQL Server Profiler to capture queries from Power BI

• Check the "Defective Objects" collection in SSAS error logs

• Run a schema compare in Visual Studio if you have the original model

Pro Tips for Recovery

• Version comparison: If you have an older working PBIX, use a diff tool to compare files

• Metadata inspection: Rename .pbix to .zip and examine DataModelSchema for errors

• Last resort: Recreate the connection while keeping visuals (use "Keep visuals" option when replacing datasource)

Prevention for Next Time

1. Set up database change alerts

2. Use consistent naming conventions

3. Consider using a staging layer (views/synonyms) to abstract direct dependencies

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[v-aatheeque]

Hi  @SherifHassan 
If the response addressed by   you received was helpful in resolving your issue, we would greatly appreciate it if you could mark it as the Accepted Answer. This action not only assists you but also benefits others in the community who may encounter similar challenges.

Should you have any further questions or require additional assistance, please don’t hesitate to provide more details. We’re always here to help!

Thank you for your continued engagement in the Microsoft Fabric Community!

[Elena_Kalina]

Hi @SherifHassan 

If the names of tables, columns, measures, or other objects in the source database or cube (e.g., SQL Server, SSAS, Oracle, etc.) have been modified, and your Power BI report references those objects, this may cause the "Unsupported Annotation name 'PBNtFormatHint'" error or other issues when opening the file.