Forum Discussion

biki's avatar
biki
Icon for Helper I rankHelper I
4 years ago
Solved

On 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...
Need Help
biki's avatar
biki
Icon for Helper I rankHelper I
4 years ago

hello Mahak, 

 

thanks for the answer, i will try the steps.

 

regards,

biki

biki's avatar
biki
Icon for Helper I rankHelper I
4 years ago

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

  • biki's avatar
    biki
    Icon for Helper I rankHelper I
    4 years ago

    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

     

     

    • bcteh's avatar
      bcteh
      Frequent Visitor
      4 years ago

      same issue here! why is this happening suddenly?

      • biki's avatar
        biki
        Icon for Helper I rankHelper I
        4 years ago

        yes, it happened so suddenly. 

         

        microsoft, anyone?

    • lucaB's avatar
      lucaB
      New Member
      1 year ago

      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