Forum Discussion
Using Power BI as a way to connect to SQL server and adding PowerApps functionality
Hi all,
I am looking for a way to create a tool that would help with storing items on pallets.
Delivery number need to be scanned and checked against record in SQL server so it shows location it need to be stored.
Then I need a functionality to save all data as delivery number, destination and time it's done in sharepoint list(what I would think could be done in PowerApps).
Only way for me is to connect to SQL via PowerBI as I am unable to use SQL connector in PowerApps.
Does anyone has an idea how this could be done?
Hi, If anyone is having the same issue, I have created a workaround for it.
I have SQL connected to Power BI report.
Using Power Automate I am pulling all data from Power BI and adding it to SharePoint that i used as data source for PowerApps.
Although it is quite a long workaround I found it as only option in my case.
3 Replies
Hi IR_06 - By embedding a PowerApps app within your Power BI report, you can create an interactive tool that allows users to scan delivery numbers, retrieve storage locations from SQL Server, and save relevant data to SharePoint. This integration leverages the strengths of both platforms while overcoming the limitation of not being able to directly connect PowerApps to SQL Server.
using Power Automate to bridge PowerApps and SQL Server:
-
Create a Power Automate Flow:
- Triggered by PowerApps.
- Connects to SQL Server using available connectors (ensure the gateway is set up if SQL Server is on-premises).
- Retrieves the storage location based on the delivery number.
- Saves the necessary data to SharePoint.
-
Integrate Flow with PowerApps:
- In PowerApps, add a button that triggers the flow.
- Pass the necessary parameters (e.g., delivery number) to the flow.
- Handle the flow’s response within PowerApps to update the UI.
Connecting Power Apps to Power Automate - How it Works and What to Expect - YouTube
How to Access Live SQL Server Data in Power Automate Desktop via ODBC (cdata.com)
hope the above information helps.
Hi, rajendraongole1 thank you for your reply.
Only problem with this solution is that I am unable to use any premium connectors so I am unable to connect to SQL Server.
-
Hi, If anyone is having the same issue, I have created a workaround for it.
I have SQL connected to Power BI report.
Using Power Automate I am pulling all data from Power BI and adding it to SharePoint that i used as data source for PowerApps.
Although it is quite a long workaround I found it as only option in my case.
