I have a report which uses an excel file in sharepoint as its source. When I refresh the report in Power BI desktop, I get the error 'Object reference not set to an instance of an object'. This repor...
Just a quick followup, after troubleshooting it turns out only SharePoint datasources without HTTPS at the begining were displaying the error. Adding https:// to the start of my SharePoint datasources has resolved the issue. Hope this helps.