I noticed that when you import and Excel there is a problem recognizing the IDs from the main "tables" because it can duplicate the IDs even if you set a column that contains the word Id or you just use Id:
The first step when you import the Excel is cleaning the Ids like this:
After it's cleaned and you import the central view to the previewer, there is another bug because you can see the "correct" data in the previewer:
But the data is invisible in the published version:
Since the intelligence is not doing the correct links, you have to be a little bit good in coding to go to this mysterious object created only in the app view:
The next issue happens because it created an ID with a number 2 at the end:
If the name is correct, it shouldn't add any extra number because it confused the app that is published. After you remove the number 2 and you republish, then all is fine:
What things should I check if I was your developer?
- Does the 1st column contain the word ID or Id and all elements are unique? If the answer is yes, I assign this value as the identifier and respect its name regardless of whether it is singular or plural. If the answer is no, I add an auto numeric ID.
- If the ColumnId in the table that contains the foreign keys has the same names as the other tables when you create the links, it should respect the names of the tables and don't create a new one with other extra values to avoid the previous bug.