When I get to Name new gateway, add recovery key, and click Configure - it fails to set it up without explanation. Just a yellow box that says: Failed to create gateway. Please try again.
@bumpyjslim
Жыл бұрын
What if i already have an API Gateway (Tyk or Kong gateway) in my infrastructure. What are the considerations / added values to add the Power BI Gateway in my infrastructure?
@LuanNguyen-pl2wf
2 жыл бұрын
I don't know why but my location show Nothern Europe while i located in West Cost just like you.
@kebincui
Жыл бұрын
Excellent❤👍🌹🌹
@Createme99
2 жыл бұрын
Wow, I always have to watch 3 different videos to figure anything out, this video got me to the finish line all on its own. Bless you for this.
@Sandroider
8 ай бұрын
how to find out where is my on-prem GW installed?
@erickrubio1700
4 жыл бұрын
The production of this video is miles ahead of the official Microsoft content... Thank you for making it widely available!
@muhammadtanweer820
6 ай бұрын
Looking for a way to have the Gateway Connection password to be automatically updated when DBA make a change to the password for the service account?? Is there a way to automate gateway connection password update?
@vamsig4450
2 жыл бұрын
HI , My gateway keeps sigiing out how to resolve it
@glaciarsoylent4859
Жыл бұрын
I don't understand, so I have to keep my computer power on in order to keep the data updated in the power bi workspace? I don't get it
@DevelopmentDev-fl6sz
11 ай бұрын
This video is clearer than real life. Good info too.
@AlexandreSantosNeves
Жыл бұрын
After a while I was able to solve my automatic refresh configuring the Power BI Gateway... You rock man. I've never found a simple video explainning that. THANK YOU... Subscribed!
@roverhern7979
5 ай бұрын
Q: hope you can help as we are having difficulty to figure this out. Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) *})
@Jay-cu8wh
Жыл бұрын
The pdf file is not accessible. Is there any other working link to download it?
@atharvnikhare7113
Жыл бұрын
Is there a way I can create a Gateway for Python Script as a Data Source?
@justsayjoe9634
Жыл бұрын
I keep running into an error message that states DM_GWPipeline_Client_GatewayUnreachable, even though the service is running. Any thoughts?
@salirtube
Жыл бұрын
I have a gatwway installed for Power BI. However when I go to develop apps in Power Apps I dont see any gateways. Can the same gatweay be used for both power bi and power apps? Is there any admin setting that has to be turned on so that I can view the gatweay within power apps.
@luigidefranco1332
2 жыл бұрын
it's amazing your training video
@sadradaneshvar4543
2 жыл бұрын
You sir are a life saver. Thanks a lot!
@TheoEkelmans
8 ай бұрын
oooookay... its jan 2024 now, and PBI UI is different... How do i connect to a datasource on this version ?
@venkatasuryanagarjunchinta8696
2 жыл бұрын
Very clear, crisp and concise.
@gzhou2012utub
2 жыл бұрын
Thank you . It helps me!
@ameyraj4947
4 жыл бұрын
Hey Adam and Patrick its been almost 2 years i have been watching your videos. Those are amazing easy to understand, very helpful for me at work as well. Thanks for the great videos🎉🎉
@shivamkapoor1827
3 ай бұрын
Hi Adam, I connected live with my ssas server in power bi but when I publish report in pbi services due to gateway issue the report is not showing actually I use service account and windows authantication method for ssas and I am unable to copy the password from services.msc to put in the gateway settings whatshould I do to resolve the issua?
@tingxuanqu1631
6 ай бұрын
Hi! If I want to link my outlook account to PowerBI. Is that considered on-premise or cloud? Can we make it cloud?
@aniruddhamukherjee2474
4 жыл бұрын
Thanks Adam, I used your video to set up the Gateway to connect my on-premises Analysis Server and SQL Server easily. Your demonstration was so simple.
@sujusuresh
2 жыл бұрын
This is really good and to the point Thanks!!!
@shreyaslahoti7542
2 жыл бұрын
Thank you for this tutorial. It's really helpful.
@klaymoon1
Жыл бұрын
Great video. Does anyone know if using a data gateway has a performance concern? Is MS Fabric considered as a data gateway?
@luigidefranco1332
2 жыл бұрын
I have create on-premises data gateway with 2 servers, loadBalancingType: Random. now when I make offline primary node, the refresh data failed. my datasource are on server intranet and on some internet page. the internet navigation works. Someone can help me where I wrong?
@lalit3153
3 жыл бұрын
Thanks for gateway explanation, how to add Salesforce reports in gateway....
@jurakovtun6763
2 жыл бұрын
Thank you so much!
@АндрейЗайцев-ю3х
3 жыл бұрын
Thank you!
@marine20able
4 жыл бұрын
Thanks this video help me understand PBI gateway a lot
@cvillejin
2 жыл бұрын
If you are using Windows Authentication for connecting to SQL server, what is the user name / pw that it's asking for? Is it the desktop user login? Because it doesn't seem to be working for me.
@Shiffo
Жыл бұрын
You should use the credentials for the SQL server and need to create credentials for the SQL Server.
@Bizza12345
2 жыл бұрын
Thanks Adam. My dataset was onprem and i was unsure why PBI service wasn't updating changes i was making/refreshing data in the .pbix from locally saved/hosted data. Was republishing the dashboard everytime...d'oh!
@AndreaRodriguez-mj2os
2 жыл бұрын
your videos never disappoint!! so good! many detailed if then statements that saved me so much time on google. thank you!
@kaiveisopeixuomo847
2 жыл бұрын
Your content is simply sensational and complete! It would be great if you could put subtitles in Portuguese/Brazil
@gloriathobejane7339
3 жыл бұрын
Wow! what an amazing explanation this is my first time of using Power BI but after watching all your videos ,All is well thanks for your help we really appreciate keep it up .You are doing great and good job thank you!!!
@CafeCentralTokyo
2 жыл бұрын
That's the one which I was looking for now!
@asureshkumarin
3 жыл бұрын
Thanks so much Adam. This is really helpful. 👍🏻
@petrutarabuta5617
3 жыл бұрын
Thanks!
@DataAnalytics2486
2 жыл бұрын
amazing, thank you
@sararodriguezperez1111
4 жыл бұрын
Really useful video! Short and full of solved doubts. Thank u!
@GuyInACube
4 жыл бұрын
Excellent! Glad it was helpful 👊
@rimkach
2 жыл бұрын
Great video
@nehachak
3 жыл бұрын
Thanks a ton
@lealombroso3883
Жыл бұрын
Wow!! Amazing video thanks ! Is it working for the free version of power bi?
@evah6449
2 жыл бұрын
Is there anything on upgrading an existing onpremise gateway?
@samuelbarvet2641
Жыл бұрын
Hi Adam, just came across your channel and subscribed, fantastic video which helped on a project I am working on at the moment, Thank You. Sam (UK)
@TopperDillon
3 жыл бұрын
Thanks for this video! Really helpful!
@nmarry3073
Жыл бұрын
Hi, thanks for the informative video. However, I do not understand the part "The DBA will not like if I try to install data gateway on SQL server". Can someone help to explain?
@mohanpuri9917
Жыл бұрын
Excellent and simple explanation with examples and visuals. Great job.
@hahahaha7023
3 жыл бұрын
6 inches ha :D
@mauriziogibran7975
2 жыл бұрын
Hi! I have a question: How to share a data source from my gateway with a guest user of my domain? I'd already added the user as guest at Azure AD of my domain, I'd already added user as user of my data source and also as administrator of my gateway, but it didn't appear to my guest.
@nishareddy6627
4 жыл бұрын
Can you please make a video on how to update gateway
@dmitriynekrasov6582
4 жыл бұрын
Amazing explanation! Keep up the good work!
@hochun836
2 жыл бұрын
Thanks. But I have a question that On-premise Data Gateway belong to User or Workspace or Tenant ?
@kartikwat
Жыл бұрын
Great video indeed. I have setup the gateway on my laptop connecting to the on prem sql database. The gateway is running properly. However, I am getting an error "On-premise data gateway failed to impersonate the user" while doing power bi dataset refresh. Struggling to understand where I am going wrong.
@chukwudieze7319
2 жыл бұрын
hi Adam does refreshing your visual have an effect on the data base i.e. slows the DB down
@aboelrouk
2 жыл бұрын
Should the gateway machine join the local AD or it can be a non-member standalone server?
@VamsiBethapudy
4 жыл бұрын
Can you mention how this method would be different from setting up a dataset in Power BI online website?
@GuyInACube
4 жыл бұрын
I'm not sure I'm following. What do you mean by setting up a dataset in Power BI Online website. How are you doing that?
@gustavorodriguez4056
Жыл бұрын
Hi, how can I replace an existing data source (not a gateway) with a gateway?
@swerick
4 жыл бұрын
Someone has some new toys and production! Woot woot! As always, thanks for the content!
@GuyInACube
4 жыл бұрын
haha yeah. It's the live stream setup. Was trying something new with this video. Makes editing a bit easier. Will probably go back and forth to change things up.
@marbowang4797
4 жыл бұрын
Sean Werick power new toys. Thanks.
@victorarayal
3 жыл бұрын
What is the best way to check is the Gateway is up and running?
@tigsik3128
4 жыл бұрын
i love it this was really helpful thank you so much. and thanks for the PDF file as well.
@mysticode
4 жыл бұрын
Great, thank you for this! Can you please do a video/series on Dataflows/Datasets and how a Power BI report connects to and then can be re-published to them in the future to make updates? Thanks
@GuyInACube
4 жыл бұрын
Appreciate the suggestion. We will add that to our backlog 👊
@kim1217
4 жыл бұрын
Helpful! And looking forward to the upcoming gateway vids 🙃 thanks for the PDF!
@GuyInACube
4 жыл бұрын
Glad you found it helpful. Thanks for watching! 👊
@titusmabwai7921
4 жыл бұрын
This is an awesome peiece.. Kindly guide on how to add Oracle database data source
@technokei6849
2 жыл бұрын
Good video. Thank you :)
@O365Academy
3 жыл бұрын
Why should we not install it in the DB server ? Security reasons ?
@kirkseyblue6629
3 жыл бұрын
Thanks. But I didn't get the big picture. Why is this necessary at all? Only conclusion is that it's like a quick link to all data sources from one connection, THE GATEWAY. For example, instead of individually setting up refresh times for each source. If that's the point, then I got it.
@joaquinmaverick82
4 жыл бұрын
Thanks for the video! Your new video equipment is fantastic, the resolution is great. I see and I ear you very well, but I missed the old type of stand up presentation :) greetings from Cordoba, Argentina
@andrefreitas1572
3 жыл бұрын
excellent
@tamlomo2904
2 жыл бұрын
Thanks for your good videos! I am wondering if there is a way to use python scripts in the standard gateways. It says that it's only available in personal mode but I want to share my reports with multiple users ...
@1yyymmmddd
4 жыл бұрын
Hi. Still somewhat confused what is the real purpose of the Gateway. When you refresh and publish your report from PBI Desktop, you actually send all your data to Microsoft cloud. When you set up a Gateway on your local machine, I understand you don't need to publish your report every now and then but rather you can set up automatic refresh on Power BI Service. But your data is still going to Microsoft cloud during the refresh, isn't it?
@GuyInACube
4 жыл бұрын
Great question. Yes the dataset resides in the Microsoft Cloud. When you go to refresh that dataset from Power BI, if you have an on-premises data source, Power BI doesn't know how to get to it to perform the refresh. That's where the gateway comes into the picture to server as that link.
@1yyymmmddd
4 жыл бұрын
@@GuyInACube OK, but then does it make any difference where your Gateway resides given that in most cases you schedule your refreshes during the off the office hours?
@chimera5588
2 жыл бұрын
Can you have a on-prem gateway and a personal gateway at the same time? We're trying to connect to an on-prem Business Central server but I cannot see it in Power BI online and we have a clustered gateway on a different server. Only the clustered gateway is showing on Power BI online.
@jinalbutani9693
4 жыл бұрын
Can I setup gateway for Azure Databricks?
@SMITDEDHIA96
4 жыл бұрын
helpful.. thank you so much!!
@chrisumphlett7172
3 жыл бұрын
We have a gateway set up, this was helpful for me to better understand its purpose. One thing I noticed in your video is how much faster the Gateway connection information loads for you when you're looking at the dataset details. For us, it sometimes takes *minutes* (gasp!). Any ideas as to why?
@eljangoolak
2 жыл бұрын
HI, what if I want to have my powerbi produce PDFs automatically and save them on Azure cloud somewhere. Would I still need a gateway to output files to the cloud?
@bartoszzawadzki1732
3 жыл бұрын
Hi. First of all I have to say - I love your videos (a lot of catching up to do). Although I have one question. If I understand correct I supposed to start gateway per user? What should I do if I want to implement PowerBi in my organization? Should I start some central gateway for all? If so what credential should I use? My own? Thanks for your help.
@RKTECH1021
2 жыл бұрын
I have created dataset connection in Power BI connected to on prem tabular server. no issues on querying model from excel connecting connection stored in Power BI but it requires VPN connection, is there a way to use same connection without VPN to be on?
@ChrisView777
4 жыл бұрын
Do you still need the Gateway with Azure ExpressRoute?
@georgelbenko
3 жыл бұрын
Is there a downside on loading a gateway on the SQL server?
@odetteaparicio7194
4 жыл бұрын
I think I'm going crazy because he tried everything, I am connecting an analysis services cube, the status of the gateway connection says that it is running ... but when I open the report it gives me the error of access to the data source
@rajendraongole7662
4 жыл бұрын
Gateway pdf link not working
@GuyInACube
4 жыл бұрын
Apologies for that. It should be working now.
@juanlauroaguirre5646
3 жыл бұрын
Thanks for great explanation, love u guys in a a cube !!! However I don't understand WHY I need a gateway to connect to a SQL Database hosted in AWS, in the CLOUD? It just does not make sense to me for the data to go all the way to a local network then back to the cloud in order to refresh reports or dashboards hosted also in the cloud. Anyone has any idea? thanks!!!!
@prakash4190
4 жыл бұрын
is there any way to add existing on-prem gateway as secondary cluster to another gateway and also is there a way to switch primary to secondary and secondary to primary?
@santoshreddyg3882
4 жыл бұрын
Hi! When we configure the PBI Gateway in server located on On-Premise private network, do we need to whitelist the Microsoft PBI Azure IP address range on On-Premise private network?
@GuyInACube
4 жыл бұрын
No. All gateway communication is outbound. Not inbound. As long as it can communicate externally on port 443, you are good.
@poorvashelke3720
4 жыл бұрын
We have import mode for PBI and data is on Azure SQL, but still I can't schedule refresh for it.Saying need gateway. As per my understanding if data is on Azure we don't need gateway. Please help me.
@spsaoperaciones4107
4 жыл бұрын
Hi!! Guy's please your help, I can't connect my ODBC with Postgresql as Gateway, because have the following error: "ODBC: The connection string is invalid. Unable to supply connection property 'uid' with credentials." Maybe the connection String is wrong? I use ODBC driver Postgresql UNICODE with: Driver={PostgreSQL UNICODE};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
@1yyymmmddd
4 жыл бұрын
Hi. Don't you have to ensure that SQL Server is configured to allow remote connections ?
@Elprise1
4 жыл бұрын
Why is it that your admin will not like you if you install the gateway on the server?
@muhammadarslankhan
3 жыл бұрын
hi i have connect to sql server and select direct query in it and i have also installed gateway software in personal mode but after publish it does not show in setting gateway section how i do this ??? can i install enterprise mode then it show and connect in other side i have also connect to sql server but this time just select import option after this it just make models but after publish it does show gateway why is show gateway in models but not in directquery report
@eldaniz.bayramov
3 жыл бұрын
Great!
@danieljust295
4 жыл бұрын
What is case I want to connect o DB on specific port? How to add such darts source to Gateway?
Пікірлер: 162