There are a lot of articles talking about integration of Power BI with SharePoint online. Can we use Power BI to generate reports from SharePoint 2013 ON-PREMISE data (list and libraries) ?


Yes, but you need the On-Premise Gateway running on a server on your network. Power BI accesses it through the gateway.

  • Thanks for the information. Can you please mention some suggested links having the details of the same ? – Amit Tyagi Jul 25 '17 at 20:18
  • It's on the Power BI site when you log in. At the top right, where you see a series of icons, click the one that looks like an arrow pointing down at a line. The drop down menu has an option for Data Gateway. – mannaggia Jul 25 '17 at 20:58
  • 1
    Be aware that there are two gateways - Personal and Enterprise. Personal GW is used only for one user and is running only when the user is signed in to PC. Enterprise gateway is running as Windows Service and is supposed to be used for all users but it requires Pro license for all users accessing the reports. – Lukas Nespor Jul 25 '17 at 21:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.