Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Import and Transform Data problem

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.

2 Replies

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

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support

    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.