cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alienvolm
Helper IV
Helper IV

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:

 

Alienvolm_0-1676381782560.png

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?  

 

Alienvolm_1-1676381881043.png

Any suggestions on how to solve these errors? 

 

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@Alienvolm,

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
DataInsights
Super User
Super User

@Alienvolm,

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thank you! 🙂

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors