Forum Discussion
Simon_Furse
Feb 25, 2021Copper Contributor
Please help with a DataSource.Error when merging two connections in power query
Hi Everyone, I have been working with a complicated series of connections merging data from different sources (Excel sheets and salesforce reports and tables) together into the format needed for ...
PBIPro
Oct 28, 2024Copper Contributor
I know this is an old post, but it seems like no solution was given anywhere online and had the same issue today myself.
The solution to the error came from a Boolean (true/false) data type in a previous step in the query I was merging into. I didn't have a specific need for as that data type so changed it to text and that seemed to do the trick. In all this error likely comes from power BI acting up due to a data type alignment issue in a previous step.