0

Has anyone tried connecting to a 4D database from Power BI? I keep getting this error when I try to connect.

The field `Field Name` already exists in the record.

What's happening is that the 4D database columns all have spaces in there. I think that's causing the problem, maybe Power BI just reads the part before the space and saw another field with the same name before the space. E.g. "School Name" and "School Address".

Is there anyway to get around this? Due to this error PowerBI won't load the data.

Noctis Skytower
  • 21,433
  • 16
  • 79
  • 117
jaywhy13
  • 1,068
  • 12
  • 16

1 Answers1

-2

I think spaces are not the issue, because I had the same problem and my fields has no spaces.

I found some where else that you have to include: select*from table-name

And thats it...

Jonathon
  • 778
  • 8
  • 21
user9420478
  • 1