Import and Transform Data problem

[Anonymous]

When importing data I can see the data in the query editor. But when I close and apply, I can no longer see 95% of the data. The cells are all blank.

Sample from the query editor, there are many more columns:

In the Data table

There is a formula in the Posting Year column that includes @Indirect. I don't know whether that has anything to do with the problem or not.

[v-chenwuz-msft]

Hi @Anonymous ,

Can you share the advance code of your table without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@Anonymous , check why there red line, It should show some error or warning