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.
I have connected Power BI with Sql DB on cloud server, and after Publish its not displaying the dashboard, can u share same with Cloud Sql instead of Excel data source?
I have installed the gateway in another server by login to my system there. Now what should I provide as windows credentials? Credentials that my system login is not working instead throwing an error saying unable to connect the datasource. What should I do?
hello is it possible to connect one gateawy in multi tenant azure ? or if is it possible install multi gateaway in one server ? or if not with docker ?
@@syncbricks other question sorry vnet data gateway is it powerbi gateaway but in cloud ? i can use this for connect my powerbi report > vnet data gateaway > azure ?
Thanks for your video. That's really nice. But I had a doubt, How to keep our gateway every time online. The report refresh is getting failed at scheduled refresh time if my system is in sleep or shutdowns. Thanks in advance.
If you keep your file in SharePoint and use the file in powerbi, it will be in cloud and you don't need your local PC to act as a server. This time after publishing your report in power bi, the gateway will access the SharePoint for file directly which is independent from your pc
What can I do if my On-premises Data Gateway (Personal Mode) does not show as an option on the "Gateway cluster name" when creating a 'New Connection'?
Thank you for this video. Really help me a lot in this process I do have a question. I manage to set this up however, if I turn off my computer will the connection break? I’m trying to have this daily refresh without my computer having to be turned on.
I have to problems in last step: 1. I can only select "Windows" as authentification method. 2. Windows username and passwort are nit correct. Which login credentials do I have to use? Where can I see/adjust them. I tried windows passwort/passwort for gateway but nothing works.
Hello Bro, We need clarity about the gateway, In our organization we use VPN for DB, So If the admin can create a report in powerBI means they are using VPN at that time. At that time only the remaining can see the report otherwise its showing error in the report. we need your input then only we can move forward it
@@syncbricks Thank you for the reply 🤗, In our organization we are using VPN for DB and then in powerBI we are connecting the DB using Direct query so we need VPN
@@syncbricks Correct in my Company We use a VPN for Datasource so we connect DB in the PowerBI Direct Method Means we need a VPN. When we need to see the report means at the time we need a VPN without a VPN we can't see the report
The credentials are validated and able to fetch data on Power BI desktop, but the credentials are not validated on service side and thus not able to refresh the data when I type my username and password it return an error ? How can I fix that
is it necessary to use the gate away because if I take the desktop version it is possible to connect to azure but if I publish the report on my powerbi report server it won't work?
I have removed the personal gateway in power bi service and when i am downloading again it is showing error saying uninstall the existing gateway and try again, how to resolve the issue
Hi, Whenever we try to add credentials using "Basic" method for data source and provide the respective database's credentials, it gives us below error Unable to update this data source's credentials. The analysis request operation is timed out before it was completed - Not sure exactly why it happening but below 2 things to be noted If we give incorrect password it returns the same error - means the error is returned even before the authentication If we give incorrect server IP then it returns a different error "a network related or instance specific error occurred..." - means the PBi Service is able to access the server when given the correct IP,port.
You are welcome Please join full course If you need discount I can offer you free. However to support my work you can buy the course that will add value to your skills
Full Course : www.udemy.com/course/microsoft-power-bi-advanced-course-desktop-dax/?referralCode=1B754977728785DC48C9
Perfecto kept getting similar errors each step along the way of setting this up. All good now, thanks for going through everything thoroughly. :)
You are welcome
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.
Follow below steps
Download report
Open in PowerBi Desktop
Edit source
Publish report
Configure gateway
For windows username and password . What if I don't have a password for my windows ?
Gate needs to connect to Windows if blank is accepted it will connect
I have connected Power BI with Sql DB on cloud server, and after Publish its not displaying the dashboard, can u share same with Cloud Sql instead of Excel data source?
It can be connected with cloud sql as well
I have installed the gateway in another server by login to my system there. Now what should I provide as windows credentials?
Credentials that my system login is not working instead throwing an error saying unable to connect the datasource. What should I do?
You need to first connect with the data store
Also i want to convert normal dashboard report into live, please explain....i have prepare the that report using direct query.
You need to have power bi online service
hello is it possible to connect one gateawy in multi tenant azure ? or if is it possible install multi gateaway in one server ? or if not with docker ?
No one gateway one tenant
You have have multiple gateway for single tenant but not multiple tenants for of one gateway
@@syncbricks is it possible install multi gateaway in one server ? like docker ?
@@syncbricks other question sorry vnet data gateway is it powerbi gateaway but in cloud ? i can use this for connect my powerbi report > vnet data gateaway > azure ?
If you are using vent gateway azure you don’t need on premises gateway. Vent gateway is to connect to Microsoft Cloud Services
@@syncbricks to my on premise report be ?
Thanks for your video. That's really nice.
But I had a doubt, How to keep our gateway every time online.
The report refresh is getting failed at scheduled refresh time if my system is in sleep or shutdowns.
Thanks in advance.
Keep the server on and schedule the refresh
If you keep your file in SharePoint and use the file in powerbi, it will be in cloud and you don't need your local PC to act as a server. This time after publishing your report in power bi, the gateway will access the SharePoint for file directly which is independent from your pc
Is there any way to refresh the report(prepared using direct querty) using power automate without using any triggers?????
Yes
It is 100% possible
@@syncbricks how ?
If i have 2 different database, i have created one gateway connection for 1st database, shall i use same gateway connection for 2nd one?
Yes gateway can be same you need to define the connection for the database
What can I do if my On-premises Data Gateway (Personal Mode) does not show as an option on the "Gateway cluster name" when creating a 'New Connection'?
Personal mode is not for enterprise
Thank you for this video. Really help me a lot in this process I do have a question. I manage to set this up however, if I turn off my computer will the connection break? I’m trying to have this daily refresh without my computer having to be turned on.
You must keep the computer on to refresh data.
I have to problems in last step:
1. I can only select "Windows" as authentification method.
2. Windows username and passwort are nit correct. Which login credentials do I have to use? Where can I see/adjust them. I tried windows passwort/passwort for gateway but nothing works.
Your windows login credentials. If you are using domain controller the domain\login followed by password
Hello Bro,
We need clarity about the gateway, In our organization we use VPN for DB, So If the admin can create a report in powerBI means they are using VPN at that time. At that time only the remaining can see the report otherwise its showing error in the report.
we need your input then only we can move forward it
Please schedule VPN when you schedule the refresh. Once refresh is completed then you don’t need VPN
@@syncbricks Thank you for the reply 🤗,
In our organization we are using VPN for DB
and then in powerBI we are connecting the DB using Direct query so we need VPN
@@syncbricks Correct in my Company We use a VPN for Datasource so we connect DB in the PowerBI Direct Method Means we need a VPN. When we need to see the report means at the time we need a VPN without a VPN we can't see the report
what port use to conect?? beacuse we neet to configure the firewall and other application sercurity
TCP 443, 5671, 5672, and from 9350 through 9354
The credentials are validated and able to fetch data on Power BI desktop, but the credentials are not validated on service side and thus not able to refresh the data when I type my username and password it return an error ? How can I fix that
Please share screenshot
amjid@syncbricks.com
is it necessary to use the gate away because if I take the desktop version it is possible to connect to azure but if I publish the report on my powerbi report server it won't work?
Gateway is required to connect dataset to PowerBI service
I have removed the personal gateway in power bi service and when i am downloading again it is showing error saying uninstall the existing gateway and try again, how to resolve the issue
Please install personal gateway again and then install using program and features and then install enterprises gateway
In my workspace gateway was setup by some other team and today i have seen that no gateway was there to my report. Can you please suggest on it
Please look for gateway in powering service
Great Video! Thanks
You are welcome
Hi,
Whenever we try to add credentials using "Basic" method for data source and provide the respective database's credentials, it gives us below error
Unable to update this data source's credentials. The analysis request operation is timed out before it was completed
- Not sure exactly why it happening but below 2 things to be noted
If we give incorrect password it returns the same error - means the error is returned even before the authentication
If we give incorrect server IP then it returns a different error "a network related or instance specific error occurred..." - means the PBi Service is able to access the server when given the correct IP,port.
Can you share screenshot amjid@syncbricks.com
thanks bro
You are welcome
I am unable to find my windows credential....can u help me
How do you login to windows? The credentials that you use to login to windows are your credentials
@@syncbricks im using custom pc
Really helped me a lot. Thanks
You are welcome
Please join full course
If you need discount I can offer you free. However to support my work you can buy the course that will add value to your skills
Thank you so much for that video.
You are welcome
Why couldn't Microsoft's documentation be this clear?
Because I am there to make it clear
Thank you for this video
You are welcome
Thank you
You are welcome
how to find key for installing Standard gateway
Which key
You don’t need key to install gateway
@@syncbricks I have installed personal gateways then when I tried to install standard it's asking for key with to create a new or recover the gateway
@@syncbricks may I have to delete the person and install the standard gateway?
windows authentication not working please help
Make sure the user details are in correct format if you are using domain. Otherwise ensure windows doesn’t have blank password
Nicely explained..Thanks a tone👍
You are welcome
Full course is also available on udemy
In case you want to support this channel you can do so by enrolling the course
is this only available for paid version?
For free and paid both
I am confused about the windows username......how do i get the username
How do you login to windows?
I ddnt set any password for my laptop. @@syncbricks
Thank you I have been able to figure it out. Initially I ddnt have a password for my laptop. I had to create one@@syncbricks
your video help me thank you so much
You are welcome please like, share and subscribe
Very usefull. Thank you!
You are welcome. Don’t forget to like share and subscribe
I'm getting sign option again and again after close.. how to solve it
remove connection and add again
Is standard mode gateway is paid or free?
Free both are free
In Authentication ... What is Windows Username and Password?
Windows user who has access to gateway and data
kindly explain properly. I am admin but I need help getting Windows Username and passowrd
@@syncbricks
I tried using the windows username and password but evey time fails and throw error of invalid credentials.
can not we use personal mod in company{organization}?
You can use but you won’t be able to share the dataset with others
Thankyou
Welcome
👍👍
You are welcome
Thanks. ?
You are welcome
Thanks for providing these informations
You are welcome