Forum Discussion
Power Query Error
Hi keckraguilar - it you click on the 'error' words shown in the screengrab the system will provide some detail regarding why specific rows are failing to import.
I'd suspect it's because the 'Patient Encounter - Patient Account Number' column has some text content and cannot be converted to a number.
if you go to the volume files table, and change the 'Patient Encounter - Patient Account Number' column to be text instead of numeric that may help the data to load.
Responsive ResidentHi keckraguilar - it you click on the 'error' words shown in the screengrab the system will provide some detail regarding why specific rows are failing to import.
I'd suspect it's because the 'Patient Encounter - Patient Account Number' column has some text content and cannot be converted to a number.
if you go to the volume files table, and change the 'Patient Encounter - Patient Account Number' column to be text instead of numeric that may help the data to load.