Adding index nullifies other columns

[DCELL]

 I have a really bizarre problem. I'm importing data from Microsoft Dynamics 365 into Power BI with the Cds connector.

My steps are:

1  Source

2  Navigation

3  Remove columns

4  Add index

And then some columns' values all become null. There is no filtering or joining before these steps

What I've tried:

-The data type is automatically recognized as Text. But just in case - adding a step to manually change it to Text still has no effect

[Anonymous]

Hi @DCELL ,

I'm not quite sure if I understand your needs accurately. I cannot reproduce your issue.

Please see if the articles below help：

Getting started using Power BI with Dataverse (D365) - Part-1 

Connecting Power BI and Dynamics 365 and other Common Data Service Data 

Hope it helps,

Community Support Team _ Caitlyn

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