How to set up a DATA GATEWAY to connect your reports to local data sources in Power BI

In this video were going to go through how to set up a data gateway in order to connect your reports on the service, to your data sources within your local on premises.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[cemakyuz]

Great video, finally a simple explanation to why we need gateways and how to use them.

[vishnupp]

You are awesome. I'm an expert in power bi because of you only

[ashaarun]

Can you do a video how to connect oracle cloud db with power bi

[jeffrey]

Hi Fernan, as always great videos.

Can you also share the dataset for this video or if not yet created can you make a video how the report was created a list would be awesome! Many thanks 🙂

[ahv]

Thanks for the video. My dataset is not refreshing because of error when I use my windows authentication and tick the Skip test connection. I am confident that my windows user and password are entered correctly but not sure why my data source is not refreshing. When I untick the Skip test connection it does not save the new changes. What should I do?

[lisarae]

How can you create a cluster after the gateway has been created. I have already bypassed the section that says "Add to an existing gateway cluster"

[raymartbalakit]

Do you have a tutorial video on how to directly fetch data from Siemen's Teamcenter to create a dashboard and Gantt chart in Power BI? Please provide the step-by-step process on how to do it. Thanks!

[thaboseboka]

getting an error when I use my windows credentials

"Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for at least one of the gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."

[andersborglund]

I’m using multiple sources to my PBI Reports, do I need to set a gateway to every single one of them?

[qzckwiy]

I have a dataset stored in a PostgreSQL database and have successfully created a Power BI dashboard. However, I am encountering challenges while setting up the gateway in the Power BI service. The issue arises due to an additional layer of security in the form of a VPN that we use to access the database. How can I establish a connection between Power BI service and the PostgreSQL database considering the presence of VPN security?

[sapnalohana]

what if we change the location of datasource so do we have to remap the location ?

[filippogermi]

i'd applied ot my sql db, connection done and system speak, but receive an error messages about lss certificate expired, can you suggest how to solve?

[kiariesamuel]

Any Video on how to set up Vnet Gateway?

[leap]

Hi, i am starting from scratch and i don't have any reports or dashboard yet. I have installed the power bi gateway where the sql server lives. When i go back to the power BI service i am unable to see any gateway options. I have used the same username and pw to login as my power bi logins when installing the gateway on the server machine. Any idea what may be the issue i am getting?

[monmorelord]

ccanyou do a video on how to run a SQL script from Power BI to ge tthe data toy want grouped and rationalised and having ot do all the steps in Power Query

[luigidefranco]

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?

[Warrior_shubham]

Hey, I have done the same and it works fine but when I am scheduling refresh it does not get refresh if my laptop is off, how can I make always online?

[sudhakarramalingam]

Hi, Kindly help me if fetching data from the server-

[hindi-english]

do we need a username and password to add a gateway?

[anilredddykanthala]

How to find my windows authentication password