Scheduled refresh on Dynamics data source - fails

Question

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 tables are coming from dynamics, therefore the dynamics source also needs to be in the gateway.When I set up the ODATA-source (with the same account/pw as in desktop), I get 'unauthorized' error.From logs i read it is an external (non-gateway error):.MashupCredentialException (0x80004005): The credentials provided for the OData source are invalid.BUTWHAT? I tried some three licensed users with access to the data source and none of them work.Data source is at Organizational privacy level, (likewise with sql source). It uses windows authentication (while oauth2 not available in OAUTH source).Any ideas, now I've been stuck with manual updates and it really bugs me.. ;(All fresh ideas are welcome, I've read the previous answers already..

greg_deckler · Answer

You could check the Issues forum here:https://community.powerbi.com/t5/Issues/idb-p/IssuesAnd if it is not there, then you could post it.If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

v-easonf-msft · Answer

Hi ,&nbsp;Anonymous&nbsp;Please&nbsp; check if&nbsp; these related posts help.https://community.powerbi.com/t5/Power-Query/Cannot-schedule-refresh-for-datasource-with-Dynamics-CRM-and-SQL/td-p/149164https://ideas.powerbi.com/ideas/idea/?ideaid=1833782d-044a-43c4-b427-65722c50d789https://powerbi.microsoft.com/zh-cn/blog/privacy-levels-for-cloud-data-sources/&nbsp;Best Regards,Community Support Team _ EasonIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

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 · Answer

Hi ， Anonymous&nbsp;&nbsp;If&nbsp; you want to refresh a report with queries that combine on-premises and cloud data sources,please check&nbsp; whether&nbsp; you have apply the option "Allow user's cloud data sources to refresh through this gateway cluster&nbsp;..." under the Gateway Cluster Settings.&nbsp;&nbsp;For more details,please erfer to this document.https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud&nbsp;Best Regards,Community Support Team _ EasonIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

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 -&gt; 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

8 Replies

Related content

Schedule refresh

Schedule refresh

Refresh/ Scheduled Refresh sudddenly disabled

Scheduled Refresh Failure

PBI Report Server Schedule refresh