Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
6 years ago

MultiSelect Option Set data from Dynamic365 to PowerBI

Hi,   I am working on project where data are coming from Dynamic365 to PowerBI. Also, i am using XRMTool Box to get some of the lables for specific fields to PowerBI because those fields have only ...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

Hi damit23183 ,

 

It is suggested to Split [Basis] column in Power Query Editor firstly. And then use UnPivot. 

 

Then, in Power BI Desktop, create relationship between the two tables.

 

After that, you can get this:

 

Or, you can create a Measure like so:

Measure = CONCATENATEX ( VALUES ( 'Basis Table'[Name] ), 'Basis Table'[Name], ", " )

 

Best Regards,

Icey

 

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

 

damit23183's avatar
damit23183
Microsoft Employee
6 years ago

Hi,

 

Thanks for your response.

 

Yes i already did same step yesterday but received an error because CASE table in this scenario is connected to other Primary table with CASEID. Therefore, becuase of this splitting step i got duplicate error on CASEIDs.

 

Now,I am trying with MERGE which does look like working but here also i can only see those data which has some values in it. However, client want to see all Basis whether they have cases or not. In this Merge scenario, tables are not map they are isolated.

 

I can get all basis but will have to map table (Basis and Cases) which will give me an error.

 

Thanks