Hi Carla,
Did you get the error message like this:
The workbook "File name" has been copied from an open workbook that contains both Power Query and PowerPivot data.
If you wish to continue using the Power Query data in this workbook, please close the following workbooks: "File name"
If yes, this issue may be caused by the data can't be used with both of the Power Query and PowerPivot at same time.
I recommend try the steps below:
- Close the workbook that mentioned of the error message, and make sure the temp file "~$filename" is closed completely.
- Re-create the data connection and does not add them to Data model to test.
If no, please give us the full error message or some screenshots.
Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"