Step by Step Procedure to Add a Data Source for On Premise Data GateWay in Microsoft Flow from Power BI Interface


Sathish Nadarajan
SharePoint MVP
Published On :   25 Mar 2018
Visit Count
Today :  2    Total :   631
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

SharePoint Office 365 Tool
Simple & Powerful Tool for Migration, Security & Reporting. Free Trial


In the earlier article, we saw about the installation of Data GateWay. In this article, let us focus on how to add the SharePoint OnPremise as a Data Source for the Data GateWay.

1. Login to the Power BI Portal, where actually our GateWay created will appear.

clip_image002

2. From the Gear Icon, click on Manage GateWays.

clip_image004

3. We can see the gateway, which we created on the previous article.

clip_image006

5. Click on the “Add Data Sources to use the gateway” hyperlink.


clip_image008

6. Give a name to the DataSource and Select the Data Source Type as SharePoint

clip_image010



7. Enter the SharePoint Site URL and the credentials.


image


8. Click on Add, the system will validate the connection and once, it is valid, the connection successful.


image



Now, we have created the connection and the Data Source successfully.  In the next article, let us see, how to use this connection on the Flow.



Happy Coding,

Sathish Nadarajan.

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

Protect Your SharePoint