Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Date column automatically splits in year/month while uploading a csv from local to PowerBI Web.

I am uploading a csv which looks like this and I want the exact same columns in powerBI dataset

 But it creates other columns that i don't want. because after this I am using rest API's to extract the same dataset in json

 

Need Help
Show and Tell

3 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion
    4 years ago

    It seems that you are transforming the date column to Year/Month/Date.

     

    Can you please share the Power Query code of your by going into "Advance Editor" in Transform Data.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I am begginer on PowerBI and doing nothing fancy just uploading the file on PowerBI Web like this

     

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Once you are uploading the csv in the Power BI service. It creates additional Hierarchy for Date Column i.e. Year & Month and keeping Date as is.

    You can ignore those columns, a better way is to download Power BI Desktop for your system and then upload the CSV file in desktop and then publish the file in the Power BI Service.

     

    you can get basic training of Power BI from Microsoft Learn

    Power BI on Microsoft Learn | Microsoft Docs