How to solve error on " The name provided is not a properly formed account name " ?

[Paulyeo11]

Hi All

I have create a PBI file for last 2 week , now all the back up file when i open , i get the same error msg below :-

[amitchandak · Accepted solution]

@Paulyeo11 , Open edit query, check more details on the error. Have you give any rule for format. There is an issue with the data type of Account Name. Make it text format and try.

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s