Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

What is the arrow symbol in a SQL DB Navigation menu (Power Query Editor)?

Hi, 

 

I have a report that is connected to an Azure SQL DB. I know that developers have changed the DB schema and now the report is throwing similar errors for two queries:

 

When I click on the Edit Settings button in the error banner, I get a Navigation pane where I can see the resource name with this arrow icon on its left. What is that?  

 

Any suggestions on how to solve these errors? 

 

  • Anonymous,

     

    The arrow icon indicates a deleted source. Here's how you can recreate it:

     

    1. Create a connection to the new source.

    2. Copy the M code for this new query (Advanced Editor).

    3. In the old query, open Advanced Editor and paste the M code that you copied from the new query.

    4. Delete the query in step 1.

2 Replies

  • Anonymous,

     

    The arrow icon indicates a deleted source. Here's how you can recreate it:

     

    1. Create a connection to the new source.

    2. Copy the M code for this new query (Advanced Editor).

    3. In the old query, open Advanced Editor and paste the M code that you copied from the new query.

    4. Delete the query in step 1.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you! 🙂