Power Query Errors

[rawiswarden]

Hello,

I am trying to merge two queries in Power Query.  For some reason, when I click from query to query I see a yellow triangle with an exclamation in the majority of my queries.  When I click any of the queries with the error, the results load and error disappears.  But when I click to the next query, the error occurs again in that prior query preventing me from doing anything with those queries.  I have no idea where to even check to see what the error message is.  Any help?

[Anonymous]

I am having an identical issue. Did you find a solution?

[v-yiruan-msft]

Hi @rawiswarden,

Could you please provide the screenshot of queries with exclamation? Is there any error message or information? In addition, can you please explain all the operations what you have done in Power BI desktop ? It should include how you connect to the data source (data source type? single or multiple data sources ? connection mode?), and the operations performed in the Power Query Editor etc. 

Before providing the above information, please try to complete the following operations to see if it can solve your problem...

1. Check the data source setting (Edit Queries --> Data source settings --> Edit Permissions OR Clear Permission and re-configure it)

          

          

     2. Check if there is any syntax error for the queries with exclamation(View --> Advanced Editor in Power Query Editor)

         

Best Regards

Rena

[rawiswarden]

Hello, I believe the issue was I was attempting to edit a query that was merged into other queries.  Where could I confirm this is the case?  Surely there must be some error that goes with the visual indication somewhere

[rawiswarden]

---

@rawiswarden wrote:

Hello, I believe the issue was I was attempting to edit a query that was merged into other queries.  Where could I confirm this is the case?  Surely there must be some error that goes with the visual indication somewhere

---

I think this was the issue.  I don't recall how I solved it - I probably removed the merge in the data flow and just merged the data in Power BI data model instead.

[v-yiruan-msft]

Hi @rawiswarden ，

Because it is not clear what data source information you used in the report and what operations you have done , I was not able to locate the problem well. Anyway, please try to check if the steps applied for each query are correct or not? Is there any error similar to the below screenshot ? You can refer to the contents of below two links to make troubleshooting and try to find solution.

https://exceloffthegrid.com/power-query-common-errors/

https://www.poweredsolutions.co/2018/03/26/query-error-auditing-in-power-query-for-excel-and-power-b...

  

In additional, you can enable Power BI desktop trace log(File –> Options –> Diagnostics –> Enable Tracing), repeat merge queries  step to reproduce the issue and check if there is any detail error information in the trace log file. You can refer to this blog.

Best Regards

Rena