When I try to refresh an Excel spreadsheet that is in a SharePoint library through Power BI the refresh takes a long time then errors out. Here is the most recent error (it's not very helpful): A...
I think I figured it out. It seems that while you can refresh locally, Power BI will fail if you do not explicitly set the data type for every field. I have done so and it seems to be working now. Hope this helps others.