Forum Discussion
DataFormat Error
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
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
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.
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
