I see the above error many times in the forum but still did not find out how to solve it.
I created a view in my database where I joined different tables and if I run it in sql is working perfectly fine.
I want to expose it in BI, by creating a repository.
I do not have dimensions or hirarchies but a fact table that I want to join with logical tables.
When I select all the fields from the same logical table, it works, but I can not mix them up with the facts or columns of the other logical tables.
It seems like there are some join missing?
Any suggestions? Attached some screen shots
Thanks and Regards
Honestly, building an RPD without dimensions or hierarchies is like building a house with external walls and roof but no plumbing, electricity, rooms or furniture.