Forum Discussion
Multiple Data Sources (and Paths) in a Power BI Workbook
It is very odd when you added a new file to the report and older report was broken, you can have multiple excel files in the same report, trying to think what could be the reason.
Is anything changed in your original (first excel file) ? May be some column type or there is missing column etc happened to the original file and that is why it is broken, I don't expect the report will break by adding new file. Very hard to see what went wrong. If there is no sensitive data, please share the pbix file and may be able to look at it.
How you connected to the excel file on google drive? What you used in "get data"?
I went to Get Data, selected Excel, and then pointed to the file on the Google Drive when prompted.
It is very odd when you added a new file to the report and older report was broken, you can have multiple excel files in the same report, trying to think what could be the reason.
Is anything changed in your original (first excel file) ? May be some column type or there is missing column etc happened to the original file and that is why it is broken, I don't expect the report will break by adding new file. Very hard to see what went wrong. If there is no sensitive data, please share the pbix file and may be able to look at it.
Seems quite odd to me too, so I am going to start over and try again. I'll let you know what happens. Thanks.