Data Source Connection Issue
Hi there. This is going to be a hard one to troubleshoot but here goes. My company has 2 process accounts that had a password change over the weekend. I have them configured in ODBC manager 64 bit and the new passwords test successfully. I then proceeded to update the passwords in the 3 dashboards that I have and refresh the data to ensure the new passwords work and the refresh is successful. However, when I publish all 3 dashboards back to the PBI server and try to refresh from there, I get a data source error - shown below. I also check the gateway settings and see the below. In my data source credentials, I see the below. I did refresh the gateway and the screen states it is online and ready to be used. I don't know what to do from here. I also tried the troubleshooting docs for PBI to no avail. Help! Thanks, LB
Gateway com banco de dados
Olá, na empresa em qual trabalho estamos como seguinte problema: O gateway está online e aparenta estar funcionando, porém quando vamos fazer a ligação, está dizendo que "O gateway ou origens de dados não estão acessíveis", abro o power bi desktop e consigo atualizar normalmente, mas no fabric acontece isso, o que posso fazer?there was a data source access error.please contact the gateway administrator
Hello, I want to create one report with SSAS (hosted on our own server). using Live connection. I've configured the on premises gateway. I have tried all the things which I found related to this. I am geeting "there was a data source access error.please contact the gateway administrator" error. Cinfigureation I have: Server where SSAS is configured. Admin User (has admin user of the srever as well as added in SSAS as admin: "anujgarg") Enterprises on premises gateway configurwed with my email and Gateway servicve account is "anujgarg") and emailID say [email protected] I have tried configureing datasource with customdata as well as with the EffectiveUserName. I have logged in as [email protected] Error: https://prnt.sc/hmEUN5D5k0CK https://prnt.sc/C9AYQhuWh9ax Please help me in get it work I assume I am missing some small peice which is causing this. Thanks. Anuj Garg
Unable to connect to database through Personal Gateway
Hello, I am having a connection issue with personal Gateway to our client database. One of our client stored their data in their database, and we managed their reporting through Power BI. Our client has created a credential and also added our IP address to whitelist to make sure we can access their data through Power BI. It worked on PBIX file and we can also refresh the data on desktop. But we want to automate the refreshing on Power BI service. So we have created a personal gateway (On Promise), but it pop up an error message when we try to connect. We have used the same credential as we used in Desktop PBIX file. It's not working through Gateway. Does anyone has the same experience? Is there any suggestion? Thank you in advance. Percy
Sharepoint Gateway
When I review the Dataset Settings -> Gateway Connections, it shows the gateway or datasources are not reachable. The Auto Refresh and Manual Refresh is working perfectly. Why won't my Sharepoint Gateway resolve to allow me to select it from the dropdown. I am having this same issue in multiple workspaces on multiple datasets that share this source.
