Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dataset not refreshing via Enterprise GATEWAY

Hi Guys,

 

So i had setup a enterprise gateway with my dataset  from mySQL DB. Gateway works fine and dataset refreshes as schduled. However i recently created another dataset...mySQL DB Connection and  tried adding to the existing gateway but i keep getting these error messages(Image Below).

 

The first dataset works just fine through the gateway but ths one keeps generating the error message as soon as i try to add it to the gateway. I have unchecked the credential option in the desktop file setting but the same error message still persists.

 

Anyway i ca fix this?

 

Need Help
Show and Tell
Tutorial Requests
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    Seems like this error happened when you configure the gateway. Please try to change the encryption into 'Not encrypted' in power bi service, not in power bi desktop.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

9 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    is the first (working) connection using encryption or not?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      The first dataset works without encryption checked. I checked both PBIX files.

       

      Encryption is unchecked.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        6 years ago

        remove the second dataset from the workspace and add it back in.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    Is it the same mySQL server?

    If so why could you not use the same data source?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Its an entirely different DB for a different product line.

       

      However both DB run on mySQL.

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    Seems like this error happened when you configure the gateway. Please try to change the encryption into 'Not encrypted' in power bi service, not in power bi desktop.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.