Solved: How to solve error on " The name provided is not a...

Paulyeo11 · ‎11-12-2020

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 · ‎11-12-2020

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎11-12-2020

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here