ksabi's avatar
ksabi
Icon for Advocate II rankAdvocate II
8 years ago
Status:
Accepted

Gateway disabled

ello, 

 

I wondr if there is someone facing the same problem as me. 

My  Enterprise Gateway was working smoothly until yesterday.  I don't know how but i cannot choose my EG to refresh my dataset : 

I created a sample report to test the datasources, in the example below the error (EG disabled) is happening when i use a merge join in my power query : 

 

when i deploy the report with this step i have this error "You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway" 

 

but deploying without the merge join, everything works fine => i can select the EG! 

 

I use Two souces in my report : 

SQLSEVER for RLS table 

Excle file for Fichier table 

 

It seems strange to have this issue after a join operation in the model. 

 

Thank you in advance for your help. 

 

Best Regards, 

KSABI

Gateways

35 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    ksabi

     

    Did you add data source for the excel file in Power BI Service - Manage gateways as below? If there are two data sources in the PBIX file, we need to add both of the sources for the data gateway.

     

     

    Best Regards,

    Herbert

    • ksabi's avatar
      ksabi
      Icon for Advocate II rankAdvocate II
      8 years ago

      v-haibl-msft

       

      Thank's for your replay. 

       

      For the file datasource i'm using a folder (it contains other folders and files). 

       

      Everything was working fine until yesterday. 

       

      I have many excel files in my reports, does it mean that should add them individually? (it worked with my folder source until yesterday!)

       

      Another information, for the existing reports the planned refresh is still working despite the fact that the EG is disabled. 

       

       

      Thank you again for your help. 

       

      Best Regards, 

      KSABI

       

      • v-haibl-msft's avatar
        v-haibl-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        ksabi

         

        How did you get data from the excel file in Power BI Desktop, through the Folder connector as below? If you're using the latest version of data gateway, could you please also try to restart the gateway?

         

         

        Best Regards,
        Herbert

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi All,

     

    I’ve reported it internally to Power BI Team: CRI 49306659
    I’ll post here once I get any update about it.

     

    Best Regards,
    Herbert

  • vgdits's avatar
    vgdits
    Frequent Visitor
    8 years ago

    Good morning,

     

    We can confirm as well, that adding each file to gateway as data source actualy bring GW back online. Before that we had only the main folder as source - like others had.

     

    As temporary solution this is just fine. But it should be fixed, so all files can be accessed via folder data source.

     

    Martin

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Anonymous

     

    Could you please also help collect the fiddler traces and shared with me? Please start the traces before publishing the report to Power BI Service, then go to the "Manage gateways" page to click "Test all connections", at last go the the scheduled refresh page.

     

     

    Best Regards,
    Herbert

  • ksabi's avatar
    ksabi
    Icon for Advocate II rankAdvocate II
    8 years ago

    Hello all, 

     

    like anselmojg and vgdits, the gateway is selectebale after declaring the files individualy. 

     

    Hope the problem will be fixed soon.

     

    Khaled

  • vgdits's avatar
    vgdits
    Frequent Visitor
    8 years ago

    Dear ksabi thanks for notice. We have already tested the workaround early in the morning when we saw previous feedback. However we hope for fix on high-level folder, as in our case this "downgrade" makes it more complex to manage.

     

    Thanks all for help.

     

    Jiri

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-haibl-msft  Fiddler tracers where inside that OneDrive link I PM'd you.  Did you get access ok?

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Anonymous

     

    I didn't see any .saz file in that directory, could you please have a check on your side?

     

    Best Regards,
    Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-haibl-msft

    I wasn't sure which format to use at the time, so i saved it with the .BAT, .HAR and a raw format (folder called RAW)

     

Completed Ideas