Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

scheduled updates and odata business central

I have 6 reports which were being updated correctly, since the beginning of the week I am having trouble updating the data from Central Business until I got "error processing data set. Dynamics365BusinessCentral: Request failed: The remote name could not be resolved: 'api.financials.dynamics.com' table ....
Activity Id: XXXX
Request Id: XXXX
Cluster Name: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Refresh Start Time: September 5, 2019 9:31 UTC
Refresh End Time: September 5, 2019 9:45 UTC

 

Try to solve it with the following without getting results:
https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

 

If someone comes up with something that can help me, I would be very grateful 🙂

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

Please share RequestID with us so we can try to find if there is any detail message internally. 

 

Best Regards,
Qiuyun Yu  

Anonymous
Not applicable

Hi, @v-qiuyu-msft 

 

Sorry 🙂 the RequestID is: 39ae28d0-583d-4b38-b89c-388f40274e99

 

Thank you very much in advance.

v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

From internal trace, I found the exception "Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request. (You have not been granted rights to add, modify, or delete this permission set for this user in this company. To obtain rights, you must be granted either the SUPER or SECURITY permission set." 

 

As the refresh works before, please check if there is any change for the data source credential recently, ensure it has permission to access related web services listed here: https://docs.microsoft.com/en-us/dynamics365/business-central/admin-powerbi#system-requirements

 

Best Regards,
Qiuyun Yu