data values problem while importing the data from sharepoint online list to the dataflow.

[Anonymous]

Hello,

 Getting [Record] & [Table] data values in the columns in the dataflow.. Once we use query editor and transform the data, it automatically deletes those columns.

I am unable to understand what I am missing here.. 

I require those columns.. how to resolve the issue.

[v-deddai1-msft]

Hi @Anonymous ,

I can't reproduce your issue. I suggest you go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". 

I would also suggest  connecting to your data in SharePoint list using Power BI Desktop and the query editor.

Once that is working, go into the advanced editor and copy the code. Then in the data flows, create a new blank query and paste the code in there.

Best Regards,

Dedmon Dai