Get started with the Power BI Gateway
Vložit
- čas přidán 2. 06. 2024
- Get to know what the Power BI Gateway is along with how to get it setup for scheduled refresh of imported data.
Free Gateway Cube Sheet: guyinacu.be/gatewaystartpdf
Gateway Documentation: docs.microsoft.com/power-bi/s...
Gateway sizing: docs.microsoft.com/power-bi/g...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #GuyInACube - Věda a technologie
The production of this video is miles ahead of the official Microsoft content... Thank you for making it widely available!
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🎉🎉
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.
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.
i love it this was really helpful thank you so much. and thanks for the PDF file as well.
your videos never disappoint!! so good! many detailed if then statements that saved me so much time on google. thank you!
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!
Excellent and simple explanation with examples and visuals. Great job.
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!!!
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
Very clear, crisp and concise.
Helpful! And looking forward to the upcoming gateway vids 🙃 thanks for the PDF!
Glad you found it helpful. Thanks for watching! 👊
Really useful video! Short and full of solved doubts. Thank u!
Excellent! Glad it was helpful 👊
Amazing explanation! Keep up the good work!
You sir are a life saver. Thanks a lot!
Someone has some new toys and production! Woot woot! As always, thanks for the content!
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.
Sean Werick power new toys. Thanks.
Thank you for this tutorial. It's really helpful.
This is really good and to the point Thanks!!!
This video is clearer than real life. Good info too.
Thanks for this video! Really helpful!
Thanks this video help me understand PBI gateway a lot
Thanks so much Adam. This is really helpful. 👍🏻
Your content is simply sensational and complete! It would be great if you could put subtitles in Portuguese/Brazil
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.
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?
Nice video! Looking forward to the next one.
Awesome! Thanks Stephen 👊
That's the one which I was looking for now!
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
Appreciate the suggestion. We will add that to our backlog 👊
Hey Adam. I'm a little unsure what the reason behind the e-mail adres you entered is. Is it only there to identify the Tenant? Or does it mean that you are the Gateway administrator?
What if your e-mail adres is entered there, but you are no longer at the company after a while? Would a replacement admin have to use the recovery key to take over the Gateway?
Thank you . It helps me!
Hi, Great video.
How do you do this for a dataset which is a csv file online, looking to get info from ECDC website daily. Any help welcome
helpful.. thank you so much!!
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!
Yo Adam, thanks for the update we've just installed a Gateway and its working fine.
It would be really useful if you could go over Gateway security in terms of connecting via the Gateway to an on prem SQL database and an SSAS Tabular model.
When sharing a PBI report:
SSAS Tabular - If a PBI report consumer is NOT a member or a read role on the Tabular model they cannot see PBI report content. When the user is added to a role that has read permissions, report content is visible - which is fine!
SQL databases - This doesn’t seem to be the same when connecting to a SQL databases, users who are NOT a member of a read role can see PBI report content - is this as expects, have I set -up something incorrectly?
When connecting directly to a SQL database are the permissions of the person sharing the report taken on by the report consumer? The only way to limit report content is with RLS? We’re on SQL Server 2014.
it's amazing your training video
Hi Adam, while trying to add a new on-prem datasource into the gateway using a service domain account with privileges over SQL db, I'm getting an error message which goes like that: "The on-premises data gateway's service account failed to impersonate the user". Any thoughts on that? Thanks for sharing!
Hi. Don't you have to ensure that SQL Server is configured to allow remote connections ?
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)
Great video. Does anyone know if using a data gateway has a performance concern? Is MS Fabric considered as a data gateway?
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?
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 ...
Hi Adam, One small doubt, when adding a data source [Data source setting part (11:12 & 10:45)] which username and password should we assign (for both sql and local file path)?
Do you still need the Gateway with Azure ExpressRoute?
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.
Wow!! Amazing video thanks ! Is it working for the free version of power bi?
hi Adam does refreshing your visual have an effect on the data base i.e. slows the DB down
Good video. Thank you :)
Thank you so much!
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!!!!
amazing, thank you
Hi Adam,
I am watching yours and Patrick's video since a year. They are awesome! Your tips and tricks add more value to my visuals. I read all comments and I have a quick question. You said when we publish the report on the Power BI service (using Import mode), the dataset resides on the Microsoft Cloud. Would like to comment anything on security? That will be a great help. I know the alternate option is to have a Power BI Report Server or have a Premium license. But I don't want to go for those alternatives.
When adding a dataset does server IP address need to be on the internal network? I can not add external IP here (to which the machine, running the Gateway, has access), can I ?
What is case I want to connect o DB on specific port? How to add such darts source to Gateway?
This is an awesome peiece.. Kindly guide on how to add Oracle database data source
Great video
Thanks for gateway explanation, how to add Salesforce reports in gateway....
great video lads
Thanks. But I have a question that On-premise Data Gateway belong to User or Workspace or Tenant ?
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.
Hi Adam, super video. Really helpful thank you. One really quick (off topic) question. What software do you use for the screen recording and more specifically screen annotations (zoom). Would be really helpful in our business. Appreciate all the effort from both yourself and Patrick. Keep up the good work mate.
This video was using the live streaming setup, so the desktop capture was way fancier than what you need. For regular videos, I just grab the desktop capture using Camtasia. But, i do all editing in Adobe Premiere. I wanted to try something different in this video to see if it made editing faster. Which it did. I'll still go back and forth.
For the on screen zoom, i used ZoomIt from sysinternals.com. If you caught the cursor spotlight and the zoomed box, that was from a paid tool called SwordSoft MouseTrack.
Thank you so much Adam. Definitely going to implement these tools. Really like the changes and once again thanks for all the great content and effort from both of you.
Should the gateway machine join the local AD or it can be a non-member standalone server?
Thank you!
Is there anything on upgrading an existing onpremise gateway?
I installed a on-prem data gateway to our company SQL server. How does the pricing works for on-prem data gateway? Does it based on power bi license or data traffic? So far I haven't seen any charges related to data gateway on the azure bill after using for few months
Thank you
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?
Maybe this is a dumb question, but how do I create a new dataset that links to the data source created in the Gateway. In your video you already had a dataset created. From a Workspace, if I select new dataset, none of the options seem to allow for creating a dataset from our on prem SQL server using the gateway. Maybe I'm misunderstanding how this is supposed to work. Thanks.
Hello Everyone,
Is it possible to schedule a refresh of an Excel or CSV file automatically in Power BI?
Any help would be really appreciated in this matter.
Thanks & Warm Regards,
Harsh
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?
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?
No. All gateway communication is outbound. Not inbound. As long as it can communicate externally on port 443, you are good.
Do you need site-to-site vpn prior to the setup of power BI gateway?
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.
Thanks!
Can you mention how this method would be different from setting up a dataset in Power BI online website?
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?
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.
How can I change the getaway of dataset after the published report?
I have a published report its current getaway is excel file and I want to change with my Sql source.
I already make my sql connection online in getaway but I don’t know how to change getaway old to new one. All the fields and values are same.
Hi,
I'm facing issues with scheduled refresh. My files are saved on local folder (.xlsx) so using Gateways to get the data load on Web. Error message is "Data Mashup error" and when I'm trying to look at detailed error message Table with error changes everytime i refresh. How to fix? Plz help
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?
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?
If I have a file in one drive can I use it in power bi.
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
I have an Azure Hosted VM where my SQL is sitting. I don't think I need a Gateway. But then I cannot configure PowerBI online. Remember nothing on premise for this. Can you please suggest what to do.
Hi! If I want to link my outlook account to PowerBI. Is that considered on-premise or cloud? Can we make it cloud?
Can I setup gateway for Azure Databricks?
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.
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.
Is there a downside on loading a gateway on the SQL server?
Thanks a ton
Why should we not install it in the DB server ? Security reasons ?
Hi, how can I replace an existing data source (not a gateway) with a gateway?
Awesome.
I have a Maria DB connection (Maria DB is running in Azure), when I try to update the dataset i get this error:
Unable to determine the data source due to unknown functions. When custom connectors are used, the error can happen if gateway doesn't have the extension enabled. Details: Query contains unknown function name: MariaDB.Contents.
The credentials in Power BI desktop are ok and the dataset is update successfully in desktop app. Could you help me please?
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?
Thanks Adam, I'm working on one project in which I wanted to connect Power bi to elastic search database real time basis. I was using REST API but it gives me only 10 k rows WEB connector, I tried with ODBC but it was not working. request you to help me here. How I will creat real time power bi dashboard by connecting with elastic search database.
Thanks in Advance
Is there any restriction for version of Windows? I am trying to install the gateway on Windows 10 PRO where I have my Power BI installed, but it tells me that my .NET has to be newer. But when I try to install the newer version of .NET it tells me that my system is not compatible with that version. I'm stuck. Any ideas? Thanks!!
Hey Adam, thanks for your video! One question though: what if I have to connect to a remote on-premise SQL Server (say, in my organization) from Power BI desktop on my laptop in order to develop a new Dataset? Is it a situation where a Gateway might give me a way to connect? Or should I simply use a VPN to get to the DB Server? Or maybe ask for the installation of Power BI Desktop onto the DB Server and connect via RDP? As you can imagine, in this period we are all working from home, so no direct access to my enterprise company network. How do I handle this?
I have the same issue right now. How did you resolve?
I am looking for the same thing
I think the best solution is to use a VPN connection for development. And for production use the datagateway.
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
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
Can you please make a video on how to update gateway
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?
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.
@@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?