DataFormat Error

[RenataOG30s]

Hi all,

I'm getting the error below when I try to refresh my data. Can you help me with this, please?

DataFormat.Error: Invalid cell value '#N/A'.

Thanks,

R.

[v-eqin-msft]

Hi @RenataOG30s ,

If you could edit the dataset in Power Query, you could insert a step before datatype formatting —— replacing that value with "null" or space.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11 · Accepted solution]

HI @RenataOG30s ,

In your new data you are having  '#N/A' value in one of your columns which ideally shouldn't have it.

Data Format error generally gives more details. Try checking at.

Also, start checking specially with the columns in your data that are not expected to have such value like primary key column used to create relationship with other tables, date columns, numeric columns, etc.

Also, it will be nice to have some more details on the issue. Just the error message doesn't help in understanding the issue properly.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[RenataOG30s]

Thanks, Pragati.

I believe the issue is with the data source, as in PBI there is a filter in a column which no longer has the required data to be filtered. I will investigate this further.

Bets,

R.

[Pragati11]

Hi @RenataOG30s ,

If in case my suggestion helped you with the issue you highlighted, then mark it as a solution. Just helps others on the forum looking for similar issue.

Thanks,

Pragati