Forum Discussion
On Premise Gateway Not Configured Correctly
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
hi Mahak, below the results:
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.
-- all the machines (gateway server, powerbi desktop server) all 64bit version
2) Create a sample report just connection and some drag and drop and publish the report to the power bi service.
-- first i tried to create a simple report online based on existing dataset in powerbi.microsoft.com, it's worked well.
-- and today, i tried to delete all datasource from powerbi.microsoft.com, then refresh locally via powerbi desktop and republish it again. i also recreated the gateway connection and added all datasets but still in datasource setting, it said gateway still not configured correctly.
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.
-- for all the services, desktop, gateway, i only used my account (adminstrator access) so i think there's no issue here (gateway status is online, each of dataset status is also online)
maybe another suggestion, pls?
thanks for your help!
regards,
biki
hello,
i tried over and over to re-map the datasource.
but the button Apply still disabled. as far as i remember, the button will enabled right after we pick the related database in maps combobox. is this somekind of bugs or something?
can anyone help me with this?
thanks!
regards,
biki
same issue here! why is this happening suddenly?
The PowerBI Desktop Connection must be the same as the connection on the PowerBI service
The File must be stored locally on your hard disk the service does non allow shared or UNC Path
You cannot use ODBC confiugred on your server , only complete connection strings
Luca
