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...
Hi sarmbrecht
So you create report in Desktop with data from SharePoint library , then publish the report to Service , then refresh the dataset failed , right ? If yes , did you configure gateway in Service ? After all, to get data from local, you need to configure gateway .
Best Regards,
Community Support Team _ Ailsa Tao