topic Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset in Desktop

Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

rcalvo — Wed, 10 May 2017 19:51:04 GMT

Hi,

I am getting the following error message when trying to refresh datasets. I am using an API conection to the Microsoft Dynamics 365 server.

I had no problem loading the entities, or creating the conections. The report seems to be fully functional as well, but when trying to refresh from Power BI Desktop, the following error message pops up.

Any help would be much appreciated!

Thanks in advance

Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

BhaveshPatel — Wed, 10 May 2017 20:51:28 GMT

It seems like you are running out of the memory!

Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

rcalvo — Wed, 10 May 2017 21:02:04 GMT

Thanks for the reply. Im running this on a computer with 16GB of memory. I have been monitoring the RAM usage during the refresh, and seems like never goes over 50%.

Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

BhaveshPatel — Wed, 10 May 2017 21:18:01 GMT

Hi ,

Can you test the refresh by reducing the no. of columns or having some constraints on your transactions table.

Are you using 32 bit or 64 bit version of PBI Desktop.

Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

rcalvo — Wed, 10 May 2017 21:52:29 GMT

Again, thank you for your responeses.

I am using the 64 bit version, and unfortunately I can't reduce the number of columns.

I tried to reduce the number of rows by filtering the field "opportunitystage" using the following expression but did not seem to work. I still get the same number of rows (95k for this entity) before and after applying the filter.

let
Source = OData.Feed("https://XXXX/api/data/v8.2/"),
opportunities_table = Source{[Name="opportunities",Signature="table"]}[Data],

filter=( "opportunitystage" = "870410007")

in
opportunities_table

Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

Anonymous — Fri, 12 May 2017 06:46:46 GMT

Hi rcalvo,

Does the error persist after you increase the size of “Maximum allowed” as shown below in Power BI Desktop?

Thanks,
Lydia Zhang

Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

rcalvo — Fri, 12 May 2017 15:17:12 GMT

Anonymous I was finally able to refresh via Power BI online. I had to remove the report and publish it again.

After that, I was able to schedule refreshes without an issue.

If it happens again, I will try your suggestion and increase the max allowd.

Thank you all for your responses!

Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

Shiva799 — Thu, 25 Jan 2018 09:15:02 GMT

I'm getting same error.

Failed to save modifications to the server. Error returned: 'The provider 'Microsoft.PowerBI.OleDb' is not registered.
The following system error occurred: Class not registered
A connection could not be made to the data source with the Name of '43867f63-dd71-474d-9612-3fd5e06e71f5'.
The database operation was cancelled because of an earlier failure.
The provider 'Microsoft.PowerBI.OleDb' is not registered.
The following system error occurred: Class not registered
A connection could not be made to the data source with the Name of '7c797a46-059b-4c27-a430-d2e907764d50'.
'.

PBI desktop is of 64-bit and my computer RAM is 8GB

What should o do to solve this?

Thanks in advance

Re: Fail to save modifications on the server - Microsoft Dynamics 365 Dataset

BT76 — Mon, 26 Jun 2023 05:38:40 GMT

I faced with the same thing. I have a customized dataset from BC365.
You should exclude the columns which is binary.
You detect and exclude these columns in Query or you can remove in BC365 customized dataset.