Understanding Office 365 Power BI-Connecting Your On Premise Data to Power BI in SharePoint Online

Power BI

By David Robson, M.R.S. BI Practice Lead


The Data Management Gateway from Microsoft allows secure direct connections to your on premise SQL Server or Oracle database instances from Power BI in SharePoint online – no more need for scheduled data refresh to reload the in memory database.

Microsoft has also introduced Power BI Analysis Services connector to allow direct connections to tabular SSAS cubes on premise from Power BI. Now you can build reports and perform analysis on-line with a secure connection to your existing assets. The connection uses the credentials of the user logged into SharePoint on-line so your cube security works just the same as it does on your local network.

Now you can create dashboards and analyses in Power BI that are directly connected to your on premise assets. There is no need to move these assets off premise and you can extend the assets you have while leveraging all of the capabilities of Power BI including the natural language Q&A feature that creates reports dynamically while you type your question.

Contact us today to discuss how we can help you with Office 365 Power BI.


About Us

M.R.S. is a full-service, relationship-centric IT consultancy firm offering our clients a compelling on-shore alternative to building and delivering best in class technology solutions. We bring experience, expertise and software development processes, refined during 35+ years of diverse client engagements, to deliver complete IT solutions that significantly improve operating efficiencies. With 10+ years of experience in SharePoint Product & Technologies, M.R.S. can be your “Go to Partner” for all your SharePoint needs.