Forum Discussion

kevinwilson1's avatar
kevinwilson1
New Member
2 years ago

Transform Data

Hi All, when trying to transform data i get a load message , i try to change first row as headers and then i get there are pending changes apply or discard i press apply, then a load box comes up with a question from the survey and i cant go any further, any ideas, very frustrating, many thanks

Tips and Tricks

7 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi kevinwilson1 

    Are you already login Power BI Desktop file or not?
    Please share screenshot to get quick answer.

    Thanks

    • kevinwilson1's avatar
      kevinwilson1
      New Member
      2 years ago

      hi, so when trying to transform the data this is the message i get and i unable to go any further, very frustrating, BW

  • kevinwilson1's avatar
    kevinwilson1
    New Member
    2 years ago

    Apologies all this is what i get, when i hit transform data, many thanks

     

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi kevinwilson1 
    Can you please share sample data or data format image
    What is the source of data?
    Better if you put some non sensitive data (2 rows) and paste here, it will helpful for me to analysis

    • kevinwilson1's avatar
      kevinwilson1
      New Member
      2 years ago

      Hi this message happens with all of the excel spreadsheets i try and transform the data with, does it make a difference if these excel sheets have been used before in previous reports? i can load the data but it comes up with columns where i want to transform this to using the row below. That is all the data i can send really due sensitivity of the data.