I'm trying to load 2 Excel sheets into Power Bi to do a data comparison.
I originally wanted to insert 3 sheets from each Excel file, but Power Bi would close without an error.
So next I tried to insert just 1 sheet, after a few attempts I managed to get it to work.
Now I want to insert another sheet to compare data, but I get the following error:
“Something went wrong”, an error occurred while the model of the item or data source “OpenConectionError”. Verify that the connection information is correct and that you have permissions to access the data source.
The Excel file is saved on my local C drive, so I’m not sure what the error is. In the background it shows the Load window and “Detecting Relationships….”.