Forum Discussion
Helper IOn Premise Gateway Not Configured Correctly
hello,
i have searched, but not found exactly the same issue.
we have on premise gateway (enterprise version) for years, abt 2 months ago, i moved the gateway to the other server. the migration process has succeed without any trouble at all. just like voila! the connection moved to the new one.
the gateway still running well actually, but this morning, i want to stop automatic refresh process for a while due to report update, turn out that Scheduled Refresh menu is disabled,
and i checked the gateway is not configured correctly.
but when i checked the gateway setting, its online.
how to configure the gateway correctly then?
pls help, thanks in advanced!
dear all,
after a week trying to solve the problem with microsoft, finally i found what was the cause.
the problem is the version of Power BI Desktop, it need to be upgraded to the latest and choose the apps from Microsoft Store, and then republish all the reports.
after that, the enterprise gateway will work smoothly.
i consider this problem has SOLVED then.
thanks to all,
biki
well, i just found out another solution, and i think Microsoft have to fix this bugs quickly.
last weekend there's some network migration in here, and this morning i've just realized that PBI gateway suddenly not connected (again).
1. first i tried to relogin the gateway, not worked, still not connected.
2. then i tried to update the gateway, relogin again, still not worked. the datasource has mapped but the button Apply still in disabled state
3. accidently i clicked the status of the Gateway (the green one), suddenly the button Apply was enable!
there, the solution has turned out so simple! is this because i updated the gateway? i don't know.
is this solution applied in the first place? i don't know either.
the gateway is running, that's all that matters.
cheers!
biki
24 Replies
bikidear all,
after a week trying to solve the problem with microsoft, finally i found what was the cause.
the problem is the version of Power BI Desktop, it need to be upgraded to the latest and choose the apps from Microsoft Store, and then republish all the reports.
after that, the enterprise gateway will work smoothly.
i consider this problem has SOLVED then.
thanks to all,
biki
To upgrade PBI desktop and republish all the reports involved alot of work!
I knew this workaround from another thread, but still, why things break in the first place?
Is microsoft going to fix it?
- biki
well, i just found out another solution, and i think Microsoft have to fix this bugs quickly.
last weekend there's some network migration in here, and this morning i've just realized that PBI gateway suddenly not connected (again).
1. first i tried to relogin the gateway, not worked, still not connected.
2. then i tried to update the gateway, relogin again, still not worked. the datasource has mapped but the button Apply still in disabled state
3. accidently i clicked the status of the Gateway (the green one), suddenly the button Apply was enable!
there, the solution has turned out so simple! is this because i updated the gateway? i don't know.
is this solution applied in the first place? i don't know either.
the gateway is running, that's all that matters.
cheers!
biki
Thank you for this hint! I had the same issue and issue got fixed by installing the Power BI Desk x86 instead of x64. Then I published my report again and the report is able to see the Data Gateway again... phew...
Hi biki ,
What data source you are using?
Have you checked whether the user is correctly added to the gateway?
Best Regards,
Jay
- biki
hi v-jayw,
thanks for the response.
i'm using sql server datasource and usually worked.
i use the administrator access so it must be has the access, right?
the problem is, the gateway is online and ready to use as shown below.
but in the datasets setting menu, the gateway connection is "not configured correctly", how do i configure correctly then?
i tried to create pbi report online using the same datasource, and it's also working well. so why there's a problem anyway? and how to fix that?
really need a help, thanks!
If the status shows not configured it means the Drivers and Configuration for that specific data source on the Gateway ( On-Premises ) are not configured. Below are the steps I would have done to ensure its correct :
1) Go to Machine Gateway and then try to check the connectivity to the database. If you using DSN then ensure both 32 and 64 are installed and configured.2) Create a sample report just connection and some drag and drop and publish the report to the power bi service.
3) Ensure in the Gateway ( Manage Gateway of the Power BI Service ) that the user who is logged in or trying to configure the connections has the right to do so.
Hope this helps.
Regards
Mahak
