Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power Query Issue

Hi, I need to import data using Power Query. However, I am not getting the right values. It seems that Power BI automatically applies these two steps (red) when I import a dataset. I dont want thi...
Need Help
Show and Tell
Tips and Tricks
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous 

 

The current table is not in a standard table format. After you delete those red steps, remove the top 3 rows. Then promote the 1st row (the old 4th row) as column headers. Then change all columns to appropriate data types. This will convert the original table into a standard table. 

 

Save the query and refresh it again. See if these changes can be remained. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I already made these steps but the problem is the red circle steps that are automatically added whenever I save it. So I save it right? Then when I edit the table again, it adds that step automatically. This makes my 0.57 reformatted to 0.5699999.