Hi
I have a data model in SSAS. I can connect to it happily using 'live connection'. I see all the tables, and their relationships appear to be in place (I can't see this directly in 'live' mode of course, but reports join as expected).
However, if I try to load some of the tables in 'import' mode, I get something completely different. The SSAS 'cube' is called 'model'. If I import (say) two tables called Account and Opportunity, I get in PBI two tables called 'model' and 'model1'. The fields in each of these tables are named as concatenations of the table and field names (e.g. Account.name, Account.gender etc.)
Also, no relationships are built between the tables.
Can someone explain what's going on and how to get my model to import normally please?
Thanks, Chris.
I have a data model in SSAS. I can connect to it happily using 'live connection'. I see all the tables, and their relationships appear to be in place (I can't see this directly in 'live' mode of course, but reports join as expected).
However, if I try to load some of the tables in 'import' mode, I get something completely different. The SSAS 'cube' is called 'model'. If I import (say) two tables called Account and Opportunity, I get in PBI two tables called 'model' and 'model1'. The fields in each of these tables are named as concatenations of the table and field names (e.g. Account.name, Account.gender etc.)
Also, no relationships are built between the tables.
Can someone explain what's going on and how to get my model to import normally please?
Thanks, Chris.
