Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to ? Multiple Elements in Sequence, SSAS Multidemensional, Analysis Service 17 (14.0.249.94)

Hi there,

can you please give a hint on the following:

 

I want to import from SSAS-multidimensional (14.0.249.94 =SSAS 2017) to PBI-Desktop (Version: 2.129.905.0 64-bit (May 2024)

to create finally a composite model to use own created measures and calendar table.

 

When using an empty PBIX-file I can create the connection easily and get the figures. But this is limited to the objects defined in the cube. Such a model is already published in PowerBI-Service to use as a semantic model to connect to.

 

In case PBI-Desktop contains already objects (one table for each calendar and metrics), I face this error: "The sequence contains several matching elements." during import of parts / all objects.

 

Please give a hint on what to change / to do in my approach.

 

thank you very much

 

Thomas