Scheduled refresh on Dynamics data source - fails

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
  Community 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
    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?

Forum Discussion

Scheduled refresh on Dynamics data source - fails