Where does one go to view the query error?
After I imported an Excel file into Power BI, the Query Editor showed one error. I then clicked on "View Error" in the following window.
Then it brought up the Query Editor. But I don't see in the Query Editor what the error message is.
Thank you for your help!
Solution
Go to edit query. You should be able to see the rows with the error separately in Queries section in the left hand side.
In Power Query, you can encounter two types of errors:
- Step-level errors
- Cell-level errors
https://learn.microsoft.com/en-us/power-query/dealing-with-errors
- Remove Alphanumeric string and following character from end of the string in power BI
- 'Exclude' slicer in Power BI
- Limiting a Slicer's Multi-Select Options by A Category
- Vega multi-line chart messed up by moving brushed area but works with fold
- Using a DAX Query to calculate a maximum value for each of my projects from two tables in a many to one relationship
- Pass a Terraform Output to an Azure DevOps Varibale
- load data into power BI from relative path
- Power BI Bacci's Gantt 2.0 - Center "Today" within viewport?
- PowerBI - Bug in function LOOKUPVALUE?
- Measure using PREVIOUSYEAR is returning BLANK on card visual but works on matrix
- how to append two columns in the same table in Power BI
- How to prevent Vega signals from resetting when changing Deneb input data via Power BI slicers
- Power BI - Unable to add icons to my table visual
- Power BI :: Calendar Table doesn't have the calendar icon
- Trying to calculate change over time using a SUMX function with DAX. but the value I get is cumulative value--how can I get the non-cumulative value?
- Data Refresh Time Estimate for Incremental Refresh without Query Folding
- How to leverage previous value in dax without yielding a circular dependency?
- How to decide between using the SharePoint folder vs web connector to access excel file?
- How to handle multiple dimension records having the same name even though they have unique key/relation with the fact table (1:M)?
- How to get historical exchange rate data from the European Central Bank API?
- How to set default of Gantt in Deneb-Vega to "ALL" instead of "Days"
- Where does one go to view the query error?
- Query regarding MDX CALL statements for stored procedures in Power BI
- Is there a way to change a True False to Yes No in PowerBI Slicer visual
- Can Incremental Refresh Work Without Query Folding?
- Vega performant toggling visibility of marks
- If the data source is a SQL Server stored procedure in PowerBI, is it possible to do query folding in PowerQuery?
- multi conditional for conditional column power query
- Add and remove items from an array using Vega signals
- select specific columns from a dataset using Vega