Transform Data

[kevinwilson1]

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

[PijushRoy]

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]

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.

[PijushRoy]

Hi @kevinwilson1 

Please clear catch

Try other data source. Try to reinstall power Bi desktop

[kevinwilson1]

Hi Tried all but re installing Power Bi, i use a secure server and power Bi is downloaded on to my laptop through a secure provider, due to security

[kevinwilson1]

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

[PijushRoy]

Hi @kevinwilson1 

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

Thanks

[kevinwilson1]

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