I created a .PBIX locally on my machine that points to 4 Excel spreadsheets in a folder on a sharepoint site. If I publish this .PBIX to PowerBI.com and refresh the dataset I get an error. Please see both screenshots.
I plan on just running the reports and dropping them in the folder and having them refresh every morning but it doesn’t seem like I can do that.
Any guidance will be very much appreciated. This is an “interim” solution into the API is fully functional from a vendor of ours.