Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Scheduled refresh on Dynamics data source - fails

Hello! My Gateway cannot refresh my Dynamics data source. This is funny, while it works fine on desktop (only way to update data). My pbix reads a date table from sql server and rest of the ta...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Is this this limitation still there:
"On premises and cloud data sources cannot currently be used in the same dataset."

I've read all the other posts already and they really do not answer to the problem.

I've tried the actual gateway service account for login, also two other account which have access to env, application and entities.. still getting the error, although they work when logging in to dynamics online.


So this happens when trying to refresh the data via gateway.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ， Anonymous 

 

If  you want to refresh a report with queries that combine on-premises and cloud data sources,please check  whether  you have apply the option "Allow user's cloud data sources to refresh through this gateway cluster ..." under the Gateway Cluster Settings.

 

 

For more details,please erfer to this document.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello, tried that already, also played with the permission levels..

    If I only have the dynamics connection in report, I do not need to use gateway and then the authentication and update works!

    When I add data from on-prem sql, I need to enable the gateway and then the dynamics authentication starts to fail.
    (AAD is synced with our local ad -> gateway connection with ad-account should work (works without gateway at least)

    Could this some way relate to:
    a) gateway service account (currently I use a local account)

    b) Microsoft account that is used when logging in when configuring the gateway?

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

      Hi , Anonymous 

      Does the privacy level is consistent in both desk and service(needed to be set to NONE)?

      And  it is suggest to use the "OAuth2"  in  service  rather than "windows" .

      In fact ,it's necessary to add  Odata data sources under “Manage gateway”,you just need to check the option "Allow user's cloud data sources to refresh through this gateway cluster" under the configured data source of sql.

       

      Have you tried to use personal gateway  if possible?

       

      Best Regards,
      Community Support Team _ Eason

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks for good hints, I'll need to run through the permission levels yet once.

        Although I have the latest gateway version, Oauth2 was not available in the gateway for OAUTH data pipelines (funny).
        Oauth2 seems to work only with SQL server data pipelines (primarily for Azure sql I guess..).

        I keep trying.. 🙂