Fix Power Bi expression.errors in Windows 10

3 minute read

Home » Fix » Fix Power Bi expression.errors in Windows 10

Microsoft Power Bi is a powerful interactive data visualization BI tool. While using the Power Bi desktop or web client you may come across some errors. One of the most common error is Power Bi expression.errors. The expression error usually comes with different error messages as reported in the Power Bi Community.

After numerous hours of researching this issue for 2 days, I am really stumped.
I have tried to create a simple function of either If or Switch and both return the above mentioned error.
I even created a sample based on the example supplied on MSDN for the IF Function, trying to use it both in the Power BI Desktop and/or Power Query for Excel 2013 (32 bit) environments. Without any luck.

In this troubleshooting guide, we have compiled a list of possible solutions to fix the Power Bi expression.errors.

Fix Power Bi expression.errors

1. Power Bi expression.error the name ‘if’ wasn’t recognized

Check the Power Query Syntax

Power Bi expression.errors

  1. This error usually occurs when there is an issue with the used power query syntax.
  2. If you are trying to use if-else query, make sure you are using the right power query syntax.
  3. Next, click OK. You will see the query editor.
  4. Now you can click on Add Rule and add more if needed.

Disable focus mode in Power BI in 3 easy steps


2. Power Bi expression.error a cyclic reference was encountered during evaluation

Check Two Tables for Dependency 

Power Bi expression.errors

  1. If you are working with two tables and the second table is dependant on the first table, then you join with Master PDB TEMP.
  2. What you can do is create a reference to MASTER PDB TEMP and editing Table 2 to the new referenced query.
  3. A new query should help you resolve the error.

3. Power Bi expression.error the name ‘left’ is not recognized

Use Power Query M

 

  1. Depending on the formula you are using, this error usually indicates that you need to use the Power Query (popularly known as M) in Query Editor.
  2. You can read more about the Power Query M formula language from the official Microsoft source.
  3. Microsoft Power Query offers a powerful data import experience with many features.

4. Power Bi expression.error the field already exists in the record

Check for Duplicate Names

  1. This is another common error and usually occurs if there are two entities with identical names in the table.
  2. For example, if you have a bucketed field and one of your field has an identical name, then Power Bi will show this error.
  3. Simply change the field name and check for any improvements.

5. Power Bi expression.error the name ‘format’ wasn’t recognized

Use Power Query Language 

  1. This error is similar to what we have discussed earlier in this article. This error usually occurs if you are creating a custom column in Query Editor with DAX syntax.
  2. What you need to do is use Power Query Language to write the formula in the Query Editor.

6. Power Bi expression.error the index is outside the bounds of the record

Check for Unallowed Characters

  1. The error, although not specific indicates that the file is outside the bounds of record.
  2. It usually means you have used characters that are not allowed. Check your table for column names that have any special character or upper case letters.

7. Power Bi expression.error value ‘preferred’ is not of the correct type

Uninstall ODBC Connector and Power Bi Client

Power Bi expression.errors

  1. This error seems to occur due to a conflict between Power Bi connectors like ODBC. It can also happen if the Power Bi client has developed a snag.
  2. To fix the error, uninstall any connection installed and also reinstall the Power Bi client.

RELATED STORIES YOU MAY LIKE:

Discussions

Next up

Google Chrome doesn’t finish downloads? Try this

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

We all know how good Google Chrome is. This is why the browser became the most popular surfing tool in the world. Usually, Chrome is […]

Continue Reading

Not enough physical memory error in VMware [FULL FIX]

Rabia Noureen avatar. By: Rabia Noureen
2 minute read

A large number of VMware users have reported encountering the following error message: Not enough physical memory is available to power this virtual machine with […]

Continue Reading

Troubles with your Uplay login? Here’s what you can do

John Taylor avatar. By: John Taylor
2 minute read

Some users have reported that they are having problems when trying to log in their Uplay client. Apparently, they receive an error message that looks […]

Continue Reading