Set Up Power BI Data Gateway to Connect On-Premise Data Sources

No video

Set Up Power BI Data Gateway to Connect On-Premise Data Sources

Рет қаралды 31,361

Күн бұрын

During this session, we will be discussing about how we can install Standard Data Gateway to connect with On-Premise Data sources like SQL Server.
In this session, we have taken an example of On-Premise SQL Server Database. I will explain step by step procedure to install a Gateway and then how we can configure a Gateway with Service account. Stay connected with me throughout the session.
During this video, we will cover the following things:
• Download Power BI Standard Data Gateway 01:31
• Install Power BI Standard Data Gateway to your Server 02:05
• Configure your Data Gateway with Power BI account 03:17
• Register Power BI account with Gateway 03:45
• Register a Standard Gateway on Computer 03:54
• Create a Data Gateway Cluster to Power BI Service 05:33
• Add Data Source to Power BI Gateway Cluster 06:01
• Configure SQL Server as On-Premise Data Gateway Cluster 06:31
• Share Data Gateway with Other Users 08:20
#PowerBI
#DataGateway
#SQLSERVER

Пікірлер: 48

@BoyClassicall 3 жыл бұрын

Awesome tutorials.

@iamdhruvinshah 3 жыл бұрын

Glad you like them!

@johns8903 2 жыл бұрын

excellent resource

@santoshsakalabaktula8135 4 жыл бұрын

Superbbb explination sir

@alfredoramirez5197 3 жыл бұрын

Wonderful work.

@yallamandab7976 3 жыл бұрын

Hi when I try to do schedule refresh installed its asking no gateways is installed in your computer then i enterprise gate way on my computer and add data source like flat file or sql but my question is after shutdown my computer the gateways down right and got issue with schedule refresh to avoid that exactly where to install who will install could you please explain

@vijaybodkhe8379 2 жыл бұрын

Hello It was mentioned you can share gateway with others [without making others as Gateway Admin],Could you please make video on that how other users can access it .

@beingrishi6450 5 ай бұрын

Can you tell me how to delete the previous version to download and install the latest on premise data gateway.. I'm unable to install and do the necessary configuration as in C drive program file I was unable to delete the filea

@Vasu83386 3 жыл бұрын

hai Dhruvin shah ,awesome tutorials and my query on this topic is i have installed gateway in my system and i am using that and when i use another system and login there will the refresh of the report would be successful or will it result in an error??

@MrSikkal 6 ай бұрын

Hi mu sql server is running on linux machine. i need to connect a PBI data source. Plz tell me how to connect it.

@cvillejin 2 жыл бұрын

Thanks for uploading. How do you login using WIndows Auth? I'm not sure what to enter for user name / pw because my SSMS login screen doesn't have any pw when I use windows auth

@pandianselvaraj9204 3 жыл бұрын

Hi, We are extracting data from postgre sql. What are the prerequites to follow to install data gatway. 1. We have one account and got power bi pro license. 2.installing data gateway on server.where postgre sql is there 3.Do we need admin access for the account from postgresql.? 4.During config should i choose windows authetication or user account authentication ?

@veerp605 3 жыл бұрын

Superb

@rajagopalreddy2116 2 жыл бұрын

Hi Dhruvin Shah , i am Using enterprice DataGatway , I Installed my Local mission , but when i scheduled the refresh time my mission should be connect internet . my question is with out internet also my gatway shuold be refresh how to do it ?? , Can we install Gatway in Power Bi service only ?

@rupeshshelar5677 11 ай бұрын

what if there is not trust between two domain then how gateway willl migrage

@DanielWeikert 3 жыл бұрын

Should the email be an admin email for the service and or the datasource. If yes why?

@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?

@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?

@naveensai5743 Жыл бұрын

can we use this approach to connect to AWS data source?

@sukanyaborthakur9885 Жыл бұрын

Hello sir is it possible to connect SQL database from VM to powerBi which is obtain in my personal system by installing gateway in VM. If possible then could you explain this in detail.

@michaelliang8601 2 жыл бұрын

hi, i follow all the steps and i still can't be able to view the source from my desktop power bi. I had setup my standard gateway and connect to my sql server. i m trying to using desktop power bi to view the data . it said it can't find the data source. please help

@gagan5742 3 жыл бұрын

Hi my data is in Ms Access, please guide how i can configure the same in data gateway to refresh report automatically.

@iamdhruvinshah 3 жыл бұрын

Apologize. I don't have any clue on access data source. If that is On-Premise data source, the procedure would be same.

@yuktibhatnagar9955 Жыл бұрын

Hello.. What we can do when data source credentials is greyed out? Any solution.. How to enable this option?

@aungthuraoo9129 3 жыл бұрын

How to solve this error "Unable to connect: We encountered an error while trying to connect to ." in power bi gateway.

@jeffrey6124 3 жыл бұрын

Will there be issue if my data/source is a SQL View?

@suneelk8450 3 жыл бұрын

If we have two SQL servers and two databases, how we configure it. Please tell me

@tomasargarate2384 3 жыл бұрын

hi, what`s the best option if i need automatic refresh for a power bi published report with data source from sql server ?

@iamdhruvinshah 3 жыл бұрын

You need to set up Enterprise Gateway and need to configure refresh. 8 Refreshes per day you can perform with Power BI Pro.

@tomasargarate2384 3 жыл бұрын

@@iamdhruvinshah thank you so much. I can also set the gateway in one computer and configure the refresh for more than one power bi pro users , right?

@chintandesai9942 2 жыл бұрын

Refresh has to do nothing with Datagateway. You can configure max. 8 Refresh in Power BI Service iteself.

@raghavendrab9913 3 жыл бұрын

hi Dhruv,, can you help me to lead on configuring on-premise data gate way to get the data from SAP .

@chintandesai9942 2 жыл бұрын

Please follow all steps shown and during time of choosing Data source, please choose SAP

@vincentsvlog1761 2 жыл бұрын

Sir, can I do it on a domain client computer which installed SQL server express?

@iamdhruvinshah 2 жыл бұрын

@vincentsvlog1761 2 жыл бұрын

@@iamdhruvinshah thanks for your info. Sir

@mudadanirakar4604 3 жыл бұрын

Where need to install Gateway , whether Developer System or in server

@iamdhruvinshah 3 жыл бұрын

Server

@lakshmankumar-sq7nr 4 жыл бұрын

hi sir, thank you video. what is "Power BI Data Gateway to Connect On-Premise Data Sources" and why do we need when we have option "GetData" in desktop PowerBI. could you please explain this. thank you sir

@prashanthsanke1212 4 жыл бұрын

Hi, In Power BI, we use Power BI desktop for developing the reports where you don't require a gateway because your Desktop application and your SQL are on premise but when you publish the reports to Power BI service which is a cloud based one, now you have to configure your on premise data sources to Power BI service that is where we use gateways. Gateway works as a bridge connection between your on premises data sources to your Power BI service. If you have a Azure SQL which is a cloud based one then you don't require a gateway because both Power BI service and your data sources are on cloud. Hope you understand, if you have any doubts on this continue the conversation.

@shoeb1359 4 жыл бұрын

Gateway is used to set up Scheduled refresh to refresh your report automatically

@lakshmankumar-sq7nr 4 жыл бұрын

@@prashanthsanke1212 thank for your respond in detailed and understandable way.

@lakshmankumar-sq7nr 4 жыл бұрын

@@prashanthsanke1212 may i have your email id please, since i have some other doubts to get clarified. mine lacshman.kumar@gmail.com

@iamdhruvinshah 4 жыл бұрын

@@prashanthsanke1212 Thanks for explaining!!!