title: how to solve Object reference not set to an instance of an object in Power BI and the source file is an Excel Macro file
body: <p>I had created a Power BI file and had shared it with my team via Sharepoint as well as via mails. But whenever they try to open the file, they are getting the error as &quot;Object reference not set to an instance of an object&quot;.
  The source file is an Excel Macro file.
  I had tried downloading the .pbix file myself, but it isn't giving me any error, I am not able to identify any root cause.
  Please guide me on this.</p>