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

[Anonymous]

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

[Anonymous]

Hi @Anonymous 

Based on your description, you can refer to the following similar thread.

Sequence contains more than one matching element - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.