Use the Gateway to create a SharePoint App

[Strizzolo]

Hi,
one of our customers asks us if it is possible to use the on-premises data gateway as a "data source" to create a SharePoint App with some KPIs inside.

Following the official documentation, the only method I know is using Azure Logic Apps / Power Automate as an intermediate tool.

Is it correct?

Thank you all.

[Anonymous]

Hi @Strizzolo ,

The On-premises data gateway acts as a bridge which provides quick and secure data transfer between on-premises data sources and Cloud services(like Power BI, Azure Analysis Services, Azure Logic Apps,  PowerApps and Power Automate). Gateway is mainly used for data refresh. Do you want to create an app which its data source is from sharepoint files in Power BI or something else? If you want to create an app in Power BI, you can refer the following documentation to create the reports in Power BI Desktop first.

Create a report on a SharePoint List in Power BI Desktop

Then publish these reports to Power BI Service, and publish app with the proper contents.

Publish an app in Power BI

Best Regards

[Strizzolo]

Hi @Anonymous,

the customer wants to develop a SharePoint application using Visual Studio with some tabs inside with some KPIs. He does not want to use Power BI.

He wants to use the Gateway to extract the data from the local source.

In my opinion it is impossible.

The approach I would follow is to create the KPIs in Power BI and then embed the report/dashboard in SharePoint.

[Anonymous · Accepted solution]

Hi @Strizzolo ，

Yes, you are right. As I describe in my previous post, the gateway only acts as a bridge which provides quick and secure data transfer between on-premises data sources and Cloud services. It can't be used as a extract data tool. I totally agree with you...

Best Regards