Share you are the MAN! nobody else has SQL videos that I can see. Not this well done. TY
@juscdarth3 жыл бұрын
I scratched my head too when I got only two screens. Immediately came to your video and got my answer. Thank you for explaining the real time issues as well.
@ShanesCows3 жыл бұрын
You're welcome!
@nderoon176 жыл бұрын
Shane you are just so awesome, keep your videos up because you're such a great trainer with your funny moments
@ShanesCows6 жыл бұрын
Thank you. I appreciate you taking the time for kind words, they are what keep me making content.
@facqns3 жыл бұрын
One again, a crystal clear explanation of the exact thing I wanted to learn.... Muchas gracias!!
@ShanesCows3 жыл бұрын
De nada (if I remember my Spanish)
@lowercaseCAPS10 ай бұрын
I'm a little late to the game as our Org is only just now starting to convert to M365, and my role is user management, currently in on-prem AD, and I want to build something in Power Apps that helps facilitate user management - onboarding, offboarding, updates, etc. From my understanding it would require a data connection like this, provided Power Apps is the same 5 years from the time of this video :) Thanks for the great content, I have a lot of research to do and videos to watch!
@ShanesCows10 ай бұрын
You have the right idea BUT the problem is going to be there isn't an easy way to manipulate AD on prem with Power Apps. If you had Cloud AD or Entra or whatever we call it this would be much easier. Maybe the idea right now is build an app to facilitate collecting info and tracking tasks, but leave the actual work of AD manipulation to PowerShell? Just a thought.
@lowercaseCAPS10 ай бұрын
@@ShanesCows Great info, thanks! Most of our tasks are done via PowerShell now, so maybe I can come up with something that tracks, like you say, and can provide historical lookup capabilities, but that can also execute (call) PowerShell scripts to perform specific tasks...? This is going to be fun 😀
@uniQue_XL4 жыл бұрын
Love your video Shane, including your humor😁
@ShanesCows4 жыл бұрын
Thanks again 😻
@Nmoor1015 ай бұрын
what a great and quick explaining
@ShanesCows5 ай бұрын
Thanks, glad it helped.
@aboody1303066 жыл бұрын
Thanks Shane , Very good stuff and lot of useful information , I have request to make a video for Power App using SQL server from scratch showing thins like update forms, multi choice, dropdown options. Thanks once again Nadir
@ShanesCows6 жыл бұрын
Thank you. Yes, that video is on my list to be made. Hopefully sooner than later. I think the list is up to almost 20.
@SauloOliveira4 жыл бұрын
Fantastic vídeo Shane, you're the man :)
@ShanesCows4 жыл бұрын
Glad to help. 😀
@sokgat70196 жыл бұрын
We love your videos.Thank you!!!
@ShanesCows6 жыл бұрын
Thank you. 😻
@ara99 Жыл бұрын
Fantastic job! Thank you!!
@ShanesCows Жыл бұрын
Glad you liked it!
@Gamers-yv2dn2 жыл бұрын
Hi Shane, Thanks for your amazing videos! I have a question to you - what is the governance strategy we must adopt as part of on-prem data gateway installation being an admin ? I have listed down my recommendation based on my experience. Let me know in case if you have any suggestions: 1. Restrict users from installing gateways. Installation must be done under admin supervision who will temporary allow the team to do gateway installation and block users once installation is done 2. Admin must review the naming conventions, description etc like "appname-test-powerbireportfinance" 3. Use Gateway Performance PBI template file for monitoring 4. We must develop power automate for governance which will do the following: 4.1: Notify users to update the latest version of gateway 4.2: Delete the gateways not in use Do you have any other recommendations ?
@tawatchaikunlawong54693 жыл бұрын
Thank you very much.
@ShanesCows3 жыл бұрын
You are welcome!
@sudhakaranna2171 Жыл бұрын
Hi shane , thanks for yours information for the gateway we need to enable any firewall on the server ?
@ShanesCows Жыл бұрын
No. The Gateway calls out to Azure instead of Power Apps calling in.
@Al.sabea.mustafa6 жыл бұрын
I love your videos, I wish you can talk about powerapps filter, like filter with name and the powerapps limitation .thanks
@ShanesCows6 жыл бұрын
Thank you for the kind words. Do you mean talk about the whole delegation challenge? That would be a good video.
@W.Wallace738 ай бұрын
Great video. I have one question: Should access to Azure be done using my personal user account? What happens if I change jobs and my account is deactivated? I assume the gateway would stop, right? In that case, should I use an account exclusively for this purpose that must have the 365 licenses, correct? Or do you recommend created a specific account for it?
@ShanesCows8 ай бұрын
Most business are creating a dedicated account for it. Good news, I think you understand the options, just need to pick the right one. Probably not the personal option though.
@NguyenTran-id4od3 жыл бұрын
Thanks a lot. Appreciate!
@ShanesCows3 жыл бұрын
You're welcome!
@carolineassucena60765 ай бұрын
Shane Great Videio tks! I have one question about connectivity from on prem to azure, if I want my traffic from on prem to azure to be encrypty I should I an vpn site to site configured despise the data gateway. Correct?
@pratikpatel7252 жыл бұрын
Hi Shane, Thanks for sharing clear explanation in video. I have one question regarding on prem connection. I have gateway installed on my machine and I can connect to database and tables fine but I can not see any data when i use control like gallery or datatables in powerapps to view the data. Is there a way i can troubleshoot the issue ?
@ritikasingh75306 жыл бұрын
Great video Shane! Just a question: Powerapp Plan 1 license is required only for the developer creating the app or users as well who would use the app to enter/view data eg. data source SQL Server?
@ShanesCows6 жыл бұрын
You must have a p1 to use the on-perm data gateway. You can use Azure SQL without a p1 license though.
@dba3579 Жыл бұрын
Shane, thanks for sharing your knowledge and time. If a SQL Server installation has more than 1 database do I need a connection for every database? Thanks in advance.
@ShanesCows Жыл бұрын
I think you would have one gateway, and then multiple connections per database. So yes.
@dba3579 Жыл бұрын
@@ShanesCows Thanks for your feedback and help. I enjoy your channel and contents.
@savillekaufman98924 жыл бұрын
Hi Shane, very good video, easy to follow, but for whatever reason it does not work for me. I am trying to link into a ProtgreSQL database. The installation completes and it shows I have PowerApps and BI Ready, however Flow keeps on saying I do not have a gateway installed. What am I missing? Do I need to somehow point my Flow at the Gateway?
@ShanesCows4 жыл бұрын
I haven't ran into that. I think what you need to do is go into Connections and add a New connection to Postgre. IN that connection specify the Gateway.
@redt993 жыл бұрын
thanks again, for the account i am using for the gateway, with the gateway be available for other users who create apps or only me.
@ShanesCows3 жыл бұрын
You can choose to share it with others or not I am pretty sure.
@mahendrenmunisamy98343 жыл бұрын
Thank you Shane
@ShanesCows3 жыл бұрын
You’re welcome 😊
@anujpathak18179 ай бұрын
Hi Shane nice video i have tried switch all the data connections from Azure sql server to onprem due the budget issues, but after that my app becomes really slow in patching records or fetching records to gallery, though i am using collection,but for first time it takes long time to load. Patching is big issues it works fine but take to long time to complete the operation. Any tips from you to improve the performance
@robertmerritt52455 жыл бұрын
Thanks so much Shane, but I still have no clue as to what a data gateway is, or when or why I would use one. Can't I just connect to SQL Server and other DBs just like I connect to Excel or SharePoint?
@ShanesCows5 жыл бұрын
If they are In the cloud yes. If they are in Orem you need the gateway
@vinalkumar69343 жыл бұрын
Hey Shane, Great video. There might be a few updates to when I'm actually watching this but I get the overall picture. Just one question, does the powerapps on-premise gateway and SQL server need to be in the same environment? I saw that you created a win VM and installed GW in it but used the SQL server instance in your host.
@ShanesCows3 жыл бұрын
I think they do but not sure. Hmm
@vedvoyager2 жыл бұрын
Hi there, Just in case, if I use some connector that link me with a mysql database. In case of that machine fall down...I have to install the gateway in other PC. Do I have to change some code in powerapps or just link my app with the new connector? How should I succeed?
@brettmurray18203 жыл бұрын
I've watched a lot of your power apps videos and they are very helpful! However, I can't seem to find anything that would show me how to connect from a power app to another tenant's M365 and use the Office365Users connector to query organizational information using an email address. I'm looking to pull down org structure type data, but the users I'm trying to get to are in a business partner's office 365 tenant, different from the one my power app is in. Business partner said I would need an app key, but I don't see anywhere in power apps to add something like that. Anyway, any help would be appreciated! Thanks.
@ShanesCows3 жыл бұрын
Hey Brett. I haven’t done it but I think you will have to look into query of the graph api. I agree a key is involved but not my bag of tricks.
@kabirdeewan47223 жыл бұрын
Hi Shane I have a PowerApps connecting to SharePoint on prem 2016. I will need a on premise data gateway which is a premium connectors. What licensing I will require so that all users can use the app including external users. PowerApps per app plan or Power Per user plan
@ShanesCows3 жыл бұрын
Sorry I am slow. Either plan would work for you. Per app is probably cheaper if you just need one app covered.
@jennylin60153 жыл бұрын
Hi My Office365 couldn't connect to because our Company MS Exchange is on-premise. It will popup "REST API" is not supported to mailbox. My office365 licience is E3. So could you have any idea to fix it? Could I use to the way your video teach. Thanks a lot
@ShanesCows3 жыл бұрын
Look for my video on the SMTP connector. Might be an option
@adamc0069 ай бұрын
Is your database on the same machine as the data gateway? Or does powerapp use the gateway on prem to locate it by machine name?
@ShanesCows9 ай бұрын
In the demo they are the same machine, but as long as they are on the same network the Gateway will find it. They don't have to be on the same machine.
@gracestarlavarez2 жыл бұрын
Do you have a tutorial for adding/viewing users in AD using onprem gateway in powerapps?
@ShanesCows2 жыл бұрын
I don't, sorry. Haven't tried that one.
@rogeriopenna90145 жыл бұрын
Hi Shane. What are the plans that I can connect to On-Premise? Because MS salesmen keep trying to push me Office 365 plans for me to use PowerApps/Flow/Sharepoint. But as you said... Office 365 plans don´t even have On-premise gateway connections?? Also, when setting up the connection, MySQL and PostGre had an icon on their right. You selected MySQL Server. What about MySQL?
@ShanesCows5 жыл бұрын
Plan1 will let you connect. Yes MySQL will work.
@neerajcoolcs0554 жыл бұрын
Hi Shane, Kindly make a video to demonstrate "How PowerApps can be connected with Oracle via Gateway". Thanks,
@ShanesCows4 жыл бұрын
I haven’t done it. Sorry. We have as a company but I don’t have a demo for it.
@tourmakerofficial70593 ай бұрын
Hi sir, I am using one on premises data gateway for SQL connection in power BI service, can I use same gateway in power automate and power apps or I need to install another one
@ShanesCows3 ай бұрын
Same one. 😎
@tourmakerofficial70593 ай бұрын
But when I am login in power automate it is asking for new gateway. My existing gateway is not coming. Why?
@sumitsati66993 ай бұрын
@@ShanesCows Hi Shane, I am also facing the same issue but I am using a free trial of power app, but I have a gateway already installed in the server and still I am not able to see the suggestion for the gateway. Is there anything related to license that causing the issue?
@glynester Жыл бұрын
Great video but I can't access "Gateways" in the location you say. Things have changed. How is this set up now in 2023? The setup of the on-premises gateway is exactly the same now as in your video. It's the on-line setup that is completely different. Please can you describe how this is done now or create a new video. :)
@CharlieDemsky5 жыл бұрын
Thank you Shane! This video is super helpful. I'm trying to follow this with SQL Server Express and I've made it all the way to creating the connection in PowerApps, but it fails to connect. I've run the network ports test from the Gateway app and everything passes, not sure why PowerApps can't find it. Is there anything special needed for the Express edition of SQL Server?
@ShanesCows5 жыл бұрын
I don’t think so. I actually made this video using Express. Not sure.
@CharlieDemsky5 жыл бұрын
@@ShanesCows thanks Shane - after a few days I figured out I needed to list the SQL Server name as PCNAME\SQLEXPRESS and not just PCNAME as you have above. Worked like a charm after that! Thanks for putting this video together.
@robertomarra24313 жыл бұрын
Hi Shane, sorry I really didn't get it when you says that Office 365 users doesn't have the abilty to use power app data connections? I mean I'm a Office 365 user and I can use data connection... so I don't know exactely what you mean with that. Can you clarify that point for me pls? Thank you, really appreciate it
@ShanesCows3 жыл бұрын
Roberto I don't know what I was talking about. Can you leave a new comment with a time stamp and I will see if I can figure it out?
@robertomarra24313 жыл бұрын
@@ShanesCows Hi Shane, is at 4:20 when you start to talk about some limits. Thnx man
@ShanesCows3 жыл бұрын
@@robertomarra2431 Okay. I was talking about licensing. Which has changed a bit. The key thing for you to know is that using the Gateway with Power Apps or Automate it is a premium connector. That means anyone who uses that app needs a premium license. The base license included with O365 does not include a premium license.
@armandolavilla26024 жыл бұрын
Good morning Shane, is there any information on switching darasources on existing apps. I currently made an app using SharePoint lists and now I want to change it over to SQL. It seems very labor intensive. And I get many errors because. I have toggles and combo boxes also. Would love to hear your advise sir.
@DominikGashii3 жыл бұрын
I’m trying to make a connection to my MySQL database but it doesn’t work. I got the gateway setup and everything but still no luck. Server is on. I get the error message “MySQL: Unable to connect to any of the specified MySQL hosts.” even though I entered all the fields correctly. Any idea on how to solve this? Any help would be very much appreciated!
@ShanesCows3 жыл бұрын
Sorry, not sure. I haven't used MySQL and POwer APps before
@PadVinderETSoft17 күн бұрын
Does the gateway need to be on the same network the the users?
@ShanesCows17 күн бұрын
The gateway and the server need to be on same network. Users don’t matter
@MrFallin4u2 жыл бұрын
Hi Shane, great video, thanks. Is it possible to use Azure AD SSO for authentication, do you have a video on that? I need help with this, thanks!
@Avellino2562 жыл бұрын
Thank you very helpful
@LeeWoodcock3 жыл бұрын
Hi Shane, great video - thank you . Subscribed. I have a question - With the on premise gateway you can allocate data connections (from the www admin) - these can be setup - shared - etc with users (and those who are admins for the Gateway itself). What i am trying to understand, and take ownership on is who can use these - as it seems from the video you can make your own connections through the gateway, but what if we (as a business) only want people to use the ones made within the Gateway itself? this way we lmiit exposeure, stop people not using their own named accounts,etc.
@ShanesCows3 жыл бұрын
Hey Lee I am not sure. Sorry I haven’t tried that scenario before
@rickoland36365 жыл бұрын
Shane, great video. One question I have an Office 365 E3 license, if I create a PowerApp using the gateway will a person with a E1 license use the PowerApp
@ShanesCows5 жыл бұрын
No. You need a p1 license to use the gateway
@jacksonbolanos82093 жыл бұрын
Saludos hombre, genial el video, simple, easy and precise, congratulatios for share your knowledge, Saludos desde Colombia.
@ShanesCows3 жыл бұрын
Thanks 🐶
@KenWarthen2 жыл бұрын
Hey Shane! Do you know if it's possible to run a SQL stored procedure from Power Automate to an on-prem database with a gateway connector?
@ShanesCows2 жыл бұрын
Ken I would assume this would work the same with on prem sql. powerapps.microsoft.com/en-us/blog/return-an-array-from-a-sql-stored-procedure-to-powerapps-split-method/
@TheCaju6 жыл бұрын
Hi Shane. great learning from you. I am developing app and data source is SQL server. I installed Gateway on my office desktop. but same app is not working on my home machine saying some gateway Error. So in this case, Do I need to install gateway on same server where SQl server installed.? Also other people from organisation is gonna use this app. So in this case how to install gateway so that I can modified app here at home pc as well as other people can use this app from office laptop/ or their personal computers?
@ShanesCows6 жыл бұрын
Howdy. The gateway needs to be installed on the same network as your SQL server and the machine you install it on needs to be running. Is your desktop at work possibly sleeping or shutdown?
@SurSaaagar6 жыл бұрын
Thank You for great videos Shane. I have a question. Is it possible to connect to SQL Server, if we are using Office 365 Enterprise E3 Licensing ? I tried connecting using cloud services, it never worked. Do you think installing data gateway would help connecting to SQL Server?
@ShanesCows6 жыл бұрын
Where is your sql server located? Yes is the answer.
@SurSaaagar6 жыл бұрын
Thank You Shane. I have another issue right now with connecting Gallery control to two data sources and displaying its data to two different forms. But I am able to connect to one data source at a time using Gallery and able to show data in only one related form. Other form doesn't show the any data when I select items in Gallery. Any help is appreciated. Thanks.
@HAL-rm8dt3 жыл бұрын
I need to retrieve data from a tool of my organisation by means of API. Can I make an http request with power automate to the organisation tool connecting with this gateway...in other words I can install the gateway on my pc connected by vpn on intranet and using the gateway to retrieve data from the tool and manage them with power automate
@HisLoveArmy5 жыл бұрын
So is the data that the app is pulling from always the live and current data from the SQL server? Or is it synced / moved and it needs to be refreshed?
@ShanesCows5 жыл бұрын
Live.
@olabodemoboluwarin27683 жыл бұрын
Dear Shane, Please how can I use this logic with power automate? Thank you
@cesaritriago70386 жыл бұрын
Great videos!!!! If u can make a video of how to move all information from a collection to a table made from SharePoint list. And viceversa.
@ShanesCows6 жыл бұрын
Thank you. Someone else asked for something very similar so there is a good chance. Can you give me more details on exactly what you are trying to accomplish? The more details, the closer hopefully the video is to an exact fit for you. Thanks
@cesaritriago70386 жыл бұрын
Hi :D Well I.m making an Apps to makes order so I made 2 Database first one with the general information of the order and the status of it. And the second one with the detail of that order (Maybe want to order 2 or more sku in 1 order). So in the edit page I had 2 forms and a table. first form to actualize information of the order. The table to show de detail of sku in that order, And de second form to add or edit and selected sku in the table, this last form only apear que I click a button for new sku o edit a sku in the table. The connection between both table I did by a Key columns call Order Number. My problem is that when I want to create a new Order I could add new products in a collection, so If I submit it then I pass the information to my table inside my database, but if I cancel the order the collection never change my data in my table for detail data for sku. In other data base the change happen in cascade for the conections, but in powerapps I make that conecction manually so if I change something in the Data 1 it doest mean that ir will erase the data created in the Data 2. I know I can do a command to erase but the user can close the application while is creating an order. So I dont want to make any change until I submit all forms.
@leonardogargano84216 жыл бұрын
Hi Thanks for your video. Please, do you have some tutorial about add a new datasource on PBI gateway using db2 database, with ODBC? Thanks!
@SAULSM173 жыл бұрын
Gracias!
@ShanesCows3 жыл бұрын
De nada 😁
@victorespinoza3556 жыл бұрын
Hi Shane! How does the update works when there is a new version. I installed DG a several months ago. I noticed when I open it that said that there is a new version available and I try to do an in-place installation or update and it failed, I had to uninstall it and reinstall it. I am pretty sure I have to update the connector on the PA application now. Do I need to uninstall the DG everytime there is a new version? Have you updated the DG and if you have how was your experience?
@ShanesCows6 жыл бұрын
I don’t have one running all the time so not sure. Email me and I will see if I cannyou more details. Shane at PowerApps911.com
@NiteshKumar-jh8ob2 жыл бұрын
Hi @Shane, I am struggling to connect UiPath API to Power Apps, can share any ideas on it
@ShanesCows2 жыл бұрын
Sorry, I have never used that API. Did you see this video? kzbin.info/www/bejne/nX3Lo3uuq7B1mqs Maybe it can give you something different to try.
@nqaiser6 жыл бұрын
thanks for a great video you made really easy to understand. i have a question, what is more secure and faster, An azure sql database fed information from an on premise application OR an on premise sql database linked to powerapps via a gateway.
@ShanesCows6 жыл бұрын
I don't know if I have an answer there. I am guessing they are both in the same ballpark of security so I would ask which scenario are you more comfortable with? Is cost a factor?
@nqaiser6 жыл бұрын
Shane Young cost is not mainly a concern, however performance is. when using a gateway, would powerapps application query the on-premises sql server everytime when someone opens an application? Would this not translate to a lot of traffic and reduced performance.
@ShanesCows6 жыл бұрын
I haven't tested it but I am 99% sure that performance would be best going against an Azure SQL Database vs. an on-prem database.
@butterz58765 жыл бұрын
Hi Shane, I created a gateway on my local machine and it pulled through in PowerApps, but when I created one on a server it doesn't pull through. The reason we'd want one on a server is so other people can use it if I leave. Any ideas?
@ShanesCows5 жыл бұрын
After you installed it on the server did you add it to your account? It should work exactly the same as when you did it on your desktop.
@butterz58765 жыл бұрын
Shane Young How do you mean add it to my account?
@techmarc78782 жыл бұрын
Hi Shane, Is there any chance you can do this again but on Locally hosted PostgreSQL
@tonyhaughton34524 жыл бұрын
Hi Shane, excellent vids big thanks for this amazing free training. I’m new to PowerApps but have powershell experience. Currently looking to use PowerApps to automate AD account creation on a hybrid environment, so need to create account on prem and not directly in AAD. Been looking into how to execute a powershell script on prem via PowerApps and potentially using flow. is using this gateway part of the solution, or do you have any tutorial vids you can point me to which might help? Thanks for any guidance you can provide 👍🏻
@ShanesCows4 жыл бұрын
Hey Tony. I have not done this scenario with on prem... I am not sure what I would try here.
@tonyhaughton34524 жыл бұрын
Shane Young Thanks for reply. Will let you know if I figure it out 👍🏻
@widuralatest5 жыл бұрын
Hi Shane. Thanks for the much informative video. Is it possible to have the data available in the PowerApp as a list so I can link it to a drop down column of another list like a Lookup?
@ShanesCows5 жыл бұрын
Yes. I don’t exactly follow what you are trying to do?
@widuralatest5 жыл бұрын
@@ShanesCows Thanks Shane for the reply. Basically I want to link the data retrieved by the gateway to a dropdown in a SharePoint list. Can I do that with powerapps gateway or the data from the gateway only accessible with in powerapps?
@ShanesCows5 жыл бұрын
Only in PowerApps. But you can customize your SharePoint list form with a PowerApps app. Would that work?
@widuralatest5 жыл бұрын
@@ShanesCows If i understood you correctly, sharepoint list can be converted to a powerapp and then it can be link to a powerapp created with gateway On Prem data to populate the data in to my list?
@ShanesCows5 жыл бұрын
Try this video. Custom SharePoint List Form with PowerApps kzbin.info/www/bejne/eJLHm2aViZ2td9k
@enarahen6 жыл бұрын
Great video, thanks. One question, can we use gateway to connect to an on premise smtp server? Thanks in advance :)
@ShanesCows6 жыл бұрын
Not that I know of. Sorry
@keshinmehta7554 жыл бұрын
Hi Shane, can we in any way upload data from excel in the device to CDS entity without using OneDrive?
@ShanesCows4 жыл бұрын
You could adapt what I show here to do that kzbin.info/www/bejne/h5S6m3SqbLaJpJY
@keshinmehta7554 жыл бұрын
@@ShanesCows thanks, but if I want to achieve this without using SharePoint as well is there a way?
@yahyabadaoui714 жыл бұрын
I WANT TO WORK WITH POWER BI AND POWERAPPS CAN 'I USE THE SAME GATEWAY OR NOT ??? SHOULD 'I DOWNLOAD A SECOND GATEWAY. IST POSSIBLE TO DOWNLOAD MORE THAN 1 DATA GATEWAY IN THE SAME VM?? THANKS
@ShanesCows4 жыл бұрын
Same gateway
@blutkraehe_official3 жыл бұрын
hi, thanks for the video, u have a idea, how we can use the gateway for a onPrem Business central`?
@ShanesCows3 жыл бұрын
Not sure Patrick. I haven’t done much with BC
@blutkraehe_official3 жыл бұрын
@@ShanesCows ok
@robertotoapanta88843 жыл бұрын
Dear community, by now im doing gateway connection same way like this video. But i got stucked with a message box "dont have license to use gateway". In my account I made lots of app over SQLServer previously even icon premiun was there. Any idea what should i do ?
@ShanesCows3 жыл бұрын
The Gateway does require a premium Power Apps license. Maybe try going and signing up for the trial to see if you can get through the error?
@annat70773 жыл бұрын
@@ShanesCows It does require the Premium license as of year.2020.
@leandroaugustosilva12746 жыл бұрын
Hi Shane! TKS a lot about this great video tutorial. I have one question: Can we conect to Oracle Database too? Regards, Leandro.
@ShanesCows6 жыл бұрын
I think you can. I have never done it but when I add a connector for Oracle it asks me for my Gateway. So I think yes.
@leandroaugustosilva12746 жыл бұрын
Hi Shane, tks for your advice. Success... In addiction, I had to install a driver (Oracle 11ghome1/ODAC) on my gateway machine host. Regards, Leandro.
@ShanesCows5 жыл бұрын
Cool
@eddietowne4 жыл бұрын
I have a Gateway installed and i can see it in PowerBi but not Power Automate or Power Apps. What am I doing wrong?
@ShanesCows4 жыл бұрын
Not sure. I haven’t ran into that before
@birdsculptures4 жыл бұрын
would it be the same process to connect to an on-premise Oracle DB?
@ShanesCows4 жыл бұрын
Should be very similar 😀
@NickBotha5 жыл бұрын
If you have two tenants A + B Tenant A has a SQL DB that you want Tenant B to see, if i create the gateway as a Service account from Tenant B in Tenant A. Will the SQL DB be accessible ?
@NickBotha5 жыл бұрын
No trust / Networks talking in the Scenario
@ShanesCows5 жыл бұрын
I don't know but I think it should be. In my video my local network was not part of the same network as my Office 365 tenant.
@NickBotha5 жыл бұрын
Thanks @@ShanesCows ! Keep up the Great work
@granand3 жыл бұрын
Hey Shane, I have office 365 from organization .. I am getting repeatedly gateway error and I did install on premises gateway and showing up in Data - > Gateway .. Is this the reason that I am running on organization license O365 that I cannot access ?
@ShanesCows3 жыл бұрын
I don’t know. Sorry
@shashank25093 жыл бұрын
Are you getting 500 error? I am getting this { "error": { "code": 500, "message": "Expression value is invalid. The template field is required.", "source": "europe-001.azure-apim.net", "path": "choose[5]\\when[1]\\choose\\when[1]", "clientRequestId": "604fb49c-d7c2-449d-8f08-b846-339422c1" } }
@granand3 жыл бұрын
@@shashank2509 I resolved my issue by deleting all my connections and flow, making sure my on-premises gateway is running and when I am making connections, one of the field actually picks up the configured gateway..
@jl13994 жыл бұрын
So are we saying that for sharepoint 2016 on prem that your Sharepoint always needs access to the internet or the power apps connection will stop working?
@ShanesCows4 жыл бұрын
The SharePoint Server needs access to the Gateway server. The Gateway server needs access to the internet. SharePoint does not need to talk to the internet directly.
@jl13994 жыл бұрын
@@ShanesCows Thanks Shane, so bottom line is my power apps will stop working if I lost internet capability.
@mehvishsajid47354 жыл бұрын
Hi Shane! Is it necessary to install it on a virtual m/c?
@ShanesCows4 жыл бұрын
No, you can install it on any machine on the network
@mehvishsajid47354 жыл бұрын
@@ShanesCows thanx! stay blessed
@peterhelms-nielsen88385 жыл бұрын
Is it possible to create an app out of the box, based on SQL data, that is in tablet/16:9 format, or are we stuck with the phone layout?
@ShanesCows5 жыл бұрын
Yes. All of my customer Apps (almost) use SQL. You start with a New, Blank Canvas app and then import your data source and design away.
@peterhelms-nielsen88385 жыл бұрын
Shane Young, ok. But I don’t get the app as “easy” as the example in the video, correct? Thank you for your reply (and your videos).
@ShanesCows5 жыл бұрын
Correct. You will have to build the app yourself.
@ajitsharma1377 Жыл бұрын
Hi Shane, Please help me to understand, any update to the DataSource from the PowerApp is with connections account or with the gateway setup account.
@ShanesCows Жыл бұрын
Connection account.
@ajitsharma1377 Жыл бұрын
@@ShanesCows Thank you !!
@tjvillanueva3966 жыл бұрын
mate do you have a video regarding how to create your own virtual machine?
@ShanesCows6 жыл бұрын
I actually do. It is in the context of SharePoint but should work for you. kzbin.info/www/bejne/ZpiapWN7Z9eZaNU
@surrealismo49374 жыл бұрын
Hi, thanks for the video. How can i get PWA project sites into sql server? I need to get all project sites to get information and make historical reports. thanks
@ShanesCows4 жыл бұрын
Yikes. I have no idea. Sorry
@ericchristoph82954 жыл бұрын
ProjectData or ProjectServerAPI.
@NarcoSarco3 жыл бұрын
Awsome!
@DanielPerez-hy6qi Жыл бұрын
Will this work with an E3 licence.. ?
@ShanesCows Жыл бұрын
Not for Power Apps. Any app with an on premise connection will be premium. None of the office licenses cover this.
@DanielPerez-hy6qi Жыл бұрын
@ShanesCows thank you very much for the info.. I take that the same applies to power automate..?
@blutkraehe_official4 жыл бұрын
hi, i have an error with MySQL ... why? Microsoft SQL works fine. "Network-related or instance-specific error when connecting to SQL Server. The server was not found or can not be accessed. Verify that the instance name is correct and that SQL Server allows remote connections. (provider: Named Pipes Provider, error: 40 - Could not open connection to SQL Server) inner exception: Microsoft SQL: Network-related or instance-specific error when connecting to SQL Server. The server was not found or can not be accessed. Verify that the instance name is correct and that SQL Server allows remote connections. (provider: Named Pipes Provider, error: 40 - Could not open connection to SQL Server) Session ID: 64c6e247-ca68-4689-9236-4f283644c4f8 all data is correct ??
@ShanesCows4 жыл бұрын
Did you use the MySQL connector instead of the sql connector?
@blutkraehe_official4 жыл бұрын
@@ShanesCows yes of course ... problem solved itself . I had to set up a remote user in mysql
@juanpabloalvarezsanchez34816 жыл бұрын
+SHANEYOUNG HELLO, HOW DO YOU DO TO LIST ELEMENTS OF A GALLERY IN POWERAPPS? FORGIVE MY INGLES USE GOOGLE TRANSLATOR
@MichaelDeBlasis1369Ай бұрын
yaaas!
@mauriceacheampong95254 жыл бұрын
my mysql localhost has no password but to connect powerapps asks for a password. what do i do
@ShanesCows4 жыл бұрын
Not sure. Sorry
@mauriceacheampong95254 жыл бұрын
@@ShanesCows Alright . Thanks anyway.
@Daviirose34 жыл бұрын
what about mysql?
@ShanesCows4 жыл бұрын
It works I am pretty sure.
@selojister4 жыл бұрын
Anybody install On-Premmiss on Linux OS?
@ShanesCows4 жыл бұрын
I don’t think it is possible
@selojister4 жыл бұрын
@@ShanesCows Thank you for qucikly respond.
@epictetus97664 жыл бұрын
It's "premises" my friend....premise is not the singular, it's an entirely different word :)
@ShanesCows4 жыл бұрын
I know. 😀 But I am not in the list of people who care if people say on prem, on premise, or on premises. Grammatically I am not correct but I have never worried about it. My buddy Todd it drives him crazy. 🙃
@PendragnTK4 жыл бұрын
Amen! I've been hitting Shane on the nose with a rolled up newspaper about this for years, decades, centuries!! and he just doesn't learn. This is one of many, many reasons I am certain he was dropped on his head at least once as a child. And maybe again as an adult.