cancel
Showing results for 
Search instead for 
Did you mean: 

PostgreSQL null issue in the number type

Hello,

 

When I try to move some of the attributes to the visual, I get error Message:

 

OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression...

 

 

I figured out that the issue is related to the number type attributes which may contain null values. Example:

 

 

Price
0.34
3.45
null
1.35

 

 

The "Price" attribute is a dimension to describe the invoice facts. If I put a step to replace null values by 0 then everything works fine. However, it's not a solution for me. I can change the data type to text and it will be fine as well, but again, it's a workaround instead of a solution.

 

Environment:

  • PostgreSQL 12.0, compiled by Visual C++ build 1914, 64-bit
  • Npgsql 4.1.0 and 4.1.3
  • Power BI Desktop 2.74.5619.862 64-bit / Power BI Service
  • DirectQuery
  • Price column is a number type without aggregation.

Did anyone have the same issue? Do you have solution for that?

 
Status: New
Comments
Community Support

Hi @Czachor

 

I would suggest you update your Power BI desktop to the latest version 2.79.5768.721 then test again. If the issue still occurs, please create a support ticket to let engineers look into the issue on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

New Member

Hi @v-qiuyu-msft ,

 

thank you for you answer. I updated to the last version of Power BI Desktop and it looks like the issue is fixed. I did a few tests and error message doesn't occur now - in PBI Desktop as well as in the cloud service.

 

Best regards,

Marek Czachorowski