Multiple Data Sources (and Paths) in a Power BI Workbook

[CraigSchulz]

I'm fairly new to using Power BI for more than rudimentary stuff. I've come to a data sourcing issue that I would like some help on. 

I have a Power BI workbook that gets data from an Excel file that resides in a Google Drive, and I generated a few reports with this data. Following that I created a new report in the same PBI workbook that gets data from a different file in a different directory. Once I did that the queries for the older report that reference the other file broke. I got error messages that the queries could not find the path and file a query was looking for. Seems to me it is pretty likely PBI can handle this type of situation, but I don't know how to set this up correctly. Any help would be appreciated.

[parry2k]

How you connected to the excel file on google drive? What you used in "get data"?

[CraigSchulz]

I went to Get Data, selected Excel, and then pointed to the file on the Google Drive when prompted.

[parry2k · Accepted solution]

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.

[CraigSchulz]

Seems quite odd to me too, so I am going to start over and try again. I'll let you know what happens. Thanks.