Forum Discussion
Use the Gateway to create a SharePoint App
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.
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
3 Replies
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.
Best Regards
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.
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
