If you have any question or concern, please let us know and also don't forget to share your feedback!
@Rahul4u283 жыл бұрын
Hi your videos are very helpful. Could you please tell us what's the different between windows authentication and basic authentication? In which scenarios do we use windows or basic authentication? Please clarify with examples thank you. Your inputs woukd be very helpful.
@uzairafridi38043 жыл бұрын
Hi I am stuck on Configuring the gateway as it's keep on giving me error: "The requested operation cannot be completed. The Computer must be trusted for delegation and the current user account must be configured to allow delegation." Can you or any other expert help me? My user account have all administrative rights using Windows SERVER 2012. I had previously installed this and was working fine. Day before yesterday i have updated the Gateway software to newer version and it stopped working, had to uninstall and tried reinstalling but failed so now installing older version and getting the above mentioned error. Thanks
@hpaek18912 жыл бұрын
it seems the gw needs tcp port 443 however, it also mentions 5671-5672 and 9350-9354. Does it need those ports opened?
@manjuyelburga980 Жыл бұрын
Thank you and a great explanation! Can you please help me with my question : what or how do I reset the recovery keys for data gateway if I have forgotten them ? Is there a way or not ?
@kunaljain21543 жыл бұрын
Thank you, sir. I really like your teaching. the way you teach the concept becomes memorable.
@BIConsultingPro3 жыл бұрын
It's my pleasure!
@kebincui Жыл бұрын
Thank you Sir. You are such a good teacher. Well explained and Very helpful ❤👍👍
@sriharid4480 Жыл бұрын
Thank you so much, it is really helpful
@bharathsp554210 ай бұрын
Very clear and perfect thanks for your all good videos 👍
@naveenrawat49032 жыл бұрын
You are a good teacher, thanks for the knowledge shared
@BIConsultingPro2 жыл бұрын
So nice of you! I appreciate your feedback!
@bhagyak25762 жыл бұрын
Thank you for making this video. Really Helpful..!!
@BIConsultingPro2 жыл бұрын
Glad it was helpful!
@sudhakarc99412 жыл бұрын
Excellent teaching
@BIConsultingPro2 жыл бұрын
Thank you for your feeback!
@debasreetripathy59623 жыл бұрын
Now that's a hit 🎯.
@ashishmohan47073 жыл бұрын
Great sir Very useful for these days Can you plzz also cover power apps
@fatjanpaloja91823 жыл бұрын
Great Can you make a video how to connect Power BI to Dynamics Nav and refresh data ?
@rohanudani6964 Жыл бұрын
Hi how you made connection with azure virtual machine despite it only follows windows authentication, it'll be huge for me if you help me figure out!
@BIConsultingPro Жыл бұрын
Hi Rohan, To connect with the VM, you need the Server Name, user name and passwords. Also, if you have your own VM, you can connect via Microsoft Remote Desktop App. There are several videos online for it.
@meghnapanchal20192 жыл бұрын
Very well explained and very helpful. Thanks!
@BIConsultingPro2 жыл бұрын
Thank you!
@dwijpatel2183 жыл бұрын
Hello Everyone, after i configure all the things in ON PREMISE DATA GATEWAY, "Installation Failed. Your organization has restrictions on who can install On-premises data gateways. Please contact your service admin or your tenant admin." This is the error that i am getting, i am the admin of that workplace, i can't figure out what to do, please can somebody help
@BIConsultingPro3 жыл бұрын
Please check this link, and read the part "Related Considerations": docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#:~:text=The%20user%20installing%20the%20gateway,environment%20as%20the%20data%20sources.
@sujithkumarjack Жыл бұрын
Well done 👍
@misharymuhammad5363 Жыл бұрын
keep up the good work. thanks
@aravindareddy64202 жыл бұрын
If I connected to SQL as direct mode Does we need gateway ?
@BIConsultingPro2 жыл бұрын
yes sir, no matter which mode you are using. If your data source is on-premise or private network, you need to use a power bi data gateway.
@aravindareddy64202 жыл бұрын
@@BIConsultingPro Tqu
@molemotshetlanyane49622 жыл бұрын
Hi I have an on-premises data gateway on my local machine that connects to a sql server. I need the IP address of the gateway so that the DB administrators can whitelist it ,where do I get the IP address?
@sanjayshukla30612 жыл бұрын
Does configuring the data source in Data Gateway to connect to data residing in AWS Athena, needs IAM Credentials??? Or it can use IAM Profile?
@aungthuraoo91293 жыл бұрын
How to solve this error "Unable to connect: We encountered an error while trying to connect to ." in power bi gateway
@samehh9112 жыл бұрын
Thank you for the Video and the information, How can I use or connect to a remote Gateway that is not installed on my local machine?
@BIConsultingPro2 жыл бұрын
First, the machine should always be where your data gateway has been installed. Secondly, you connect data gateway on Power BI Service, not on Power BI Desktop, so there should be a proper authentication method.
@adammorra38132 жыл бұрын
Can i use this with always encrypted enabled on azure sql server
@BIConsultingPro2 жыл бұрын
I think yes, however please check again.
@TheSonu019 Жыл бұрын
HI Sir, I am having one issue in Gateway. I have configured the Gateway with some userid and pwd , but after sometime that will expire , so i just want that person who configured should get the mail before expiration and how can we update that credentials. in gateway.
@BIConsultingPro Жыл бұрын
Unfortunately, you won't get any email about credential expiration as this has to do with your AAD (Azure Active Directory). You use your official credentials so you'll get email from your O365 side not Gateway side. So, you need to connect with you O365 admin.
@kummithavenkatareddy2302 Жыл бұрын
what is on premises data ( the data is in client side or in your laptop )?
@BIConsultingPro Жыл бұрын
In simple terms, data that is disconnected from the Internet is on-premise data.
@Rahul4u283 жыл бұрын
Hi your videos are very helpful. Could you please tell us what's the different between windows authentication and basic authentication? In which scenarios do we use windows or basic authentication? Please clarify with examples thank you. Your inputs woukd be very helpful.
@eleftheriakoniari33922 жыл бұрын
Hi! Thank you for this video. One question though. Where should the data gateway be installed? If we have an Microsoft SQL server and several files in the on premise network, where should we install it? Thank you in advance!
@BIConsultingPro2 жыл бұрын
Hi, thanks for your comment/feedback. While installing Power BI Data Gateway, kindly following the following best practices: 1) Install Power BI Data Gateway as close as possible to the Data Source. 2) Installation must be done on a machine that is 24/7 hours online. For example Virtual Machines or on a cloud server. I hope this would help you. Good luck!
@eleftheriakoniari33922 жыл бұрын
@@BIConsultingPro thank you for your help!!!!
@BIConsultingPro2 жыл бұрын
@@eleftheriakoniari3392 anytime :)
@BISimplifier Жыл бұрын
It would be better if you assign the capacity to the same region as well.
@Travelwithus3049 ай бұрын
Can you explain what is gateway cluster?
@AmritaGuha19453 жыл бұрын
Thank you for making this video. Really Helpful..!! I have few questions: I have created and published one report in Power BI Service, by data source is SQL Server and I can easily do the schedule refresh without creating any gateway. iIn the Data Gateway Connection it is showing: "You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect. ". what does this mean? when do I need a gateway, in your example too you have connected with SQL Server but still you needed a gateway. When the gateway is actually needed because in my case I don't have any gateway still I can schedule refresh my dataset?
@BIConsultingPro3 жыл бұрын
It's because you are using cloud-based "SQL Server" which means Azure SQL DB. Your database is no on-premise-based.
@chrisjasa38003 жыл бұрын
I work for a company and have a gateway installed already, in order to make several reports in Power BI, and now I want to do the same for our sister company. Whenever I do any work for the sister company I have to work through a remote desktop, so my question is: do I have to setup a new gateway, in order to set up an automatic refresh for my Power Bi Reports? (tyi. the reports is a mix of data from an SQL server and Excel file). thx in advance
@BIConsultingPro3 жыл бұрын
Check this post: community.powerbi.com/t5/Service/Sharing-a-Gateway-Across-Tenants/m-p/686316
@samsonshewangizaw99712 жыл бұрын
Can Data Getaway can pull data from the server/database without having connection to the database by using direct query or import method?
@BIConsultingPro2 жыл бұрын
Gateway is just a bridge between source and Power BI service. However, to enter or get data from source, you would need credentials.
@hamdimestiri8642 жыл бұрын
Thank you for this video, I have one question plz: Iam using a PowerBi dataset for reports and want to deploy standard datagateway to refresh this dataset which is published on workspace and using pro licence, data gateway will be installed on windows server virtual machine. My question is : is a Power Bi premium licence required in order to connect data gateway with the Power Bi dataset or we can do it with pro licence? thanks
@BIConsultingPro2 жыл бұрын
Thanks for your question. Power BI Data Gateway has nothing to do with your license. You can use it with any kind of license. You need a license to share the content such as reports.
@vishnumekala89422 жыл бұрын
scheduled refresh is not working only if the system in which gateway is installed is shutdown state all sources are in online.
@BIConsultingPro Жыл бұрын
It should run 24x7 hours. That's why I always encourage people to use a cloud based server. If your application is not running, then you cannot see the results. Here, I am talking about application as Power BI Data Gateway. If machine is shut down, how will it work?
@vishnumekala8942 Жыл бұрын
@@BIConsultingPro So you mean that application should run 24/7 ,that means my organisation laptop should be in power on state 24/7,then what is the use of the feature scheduled refresh,instead we can do on demand refresh whenever we want right?
@BIConsultingPro Жыл бұрын
@@vishnumekala8942 My friend, have you heard about servers? Servers run 24X7. Secondly, the gateway should be installed on the cloud server NOT on personal machines. Lastly, you can switch it on or off if you want. However, it should be on at the time of schedule refresh. If your server is off, then no matter what automation you have planned, nothing would work irrespective of Power BI Gateway
@vishnumekala8942 Жыл бұрын
@@BIConsultingPro Thanks Bro, Now I am getting clarity ,But could you provide me the video on how to install it in cloud servers. In the video you have explained how to install on premise gateway in person pc.
@BIConsultingPro Жыл бұрын
@@vishnumekala8942 it is exactly the same way. Just make sure it’s a windows server
@suneelk84503 жыл бұрын
Hi, If we have two server names and two databases in the same machine, how we configure it.
@BIConsultingPro3 жыл бұрын
Try to create a cluster! docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#add-another-gateway-to-create-a-cluster
@teja4658 Жыл бұрын
Hai i m facing an issue with gateway Here the issue is Actually I kept schedule refresh but it only refreshing when my vpn is on and when ever my system and vpn is off it’s not getting refreshed Could you please suggest me what to do i m working in VM mode
@BIConsultingPro Жыл бұрын
Thanks for your question. I believe you have installed Power BI Data Gateway on your own system which I never recommend. You should install it on your organizations server which is 24X7 hours available. That would be always on companies VPN Or private network. When you installed on your machine then it needs to authenticate your machine against organizations network. Once your VPN is connected, only then this would work, otherwise it won't due to security concerns. I hope I am able to answer your question. Please let me know if you have any further questions or concern.
@salwakhalyl77372 ай бұрын
Thank you very much, please where can i find the username and password in the section of authentication?
@BIConsultingPro2 ай бұрын
Have you already installed the gateway? If yes, then please make sure to start the machine where it’s installed and restart the gateway if required. Now, go to Power BI Service and go to the gateway management tab (Click on top hand right side, where admin portal options appears). There you can add a new connection and you’ll get the option.
@ankitanayee8759 Жыл бұрын
network request returned unexpected error power bi personal gateway
@BIConsultingPro Жыл бұрын
Please check your Gateway Status. Might be credentials needs to enter again or they have changed. You need to authenticate again. Also, check your LAN or VPN connection
@Harishkumar-xv2wp3 жыл бұрын
In DataFlow, how to reference to data gateway? Without this we will not be able to update the corresponding data gateway if the password changed.
like ma ek window user hu or ma window authanticaion se login krta hu mane power bi report bana de mere liye to data refresh ho gya ab aapke pass sql server ka excess nhe ha ab mane bol diya ki data refersh kr diya ab aap powerbi ke ander pull kr lo ho jayega ab aapko issue aa raha ha kyoki aapke pass sql ka to login he nahe ha iska work around find out krna ha ki aap us data ko kaise referesh kr sakhte ho without creating user in database .
@BIConsultingPro3 жыл бұрын
Ask someone to publish the report who has the access. Only Admin (who would publish the report/dataset) needs to have access, not the consumer. Only one access required. Also, if none of the admins have access, then, unfortunately, it's not possible.