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

[rcalvo]

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

[BhaveshPatel]

It seems like you are running out of the memory!

[rcalvo]

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%.

[BhaveshPatel]

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.

[rcalvo]

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

[v-yuezhe-msft]

Hi @rcalvo,

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

Thanks,
Lydia Zhang

[Shiva799]

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

[rcalvo · Accepted solution]

@v-yuezhe-msft 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!

[BT76]

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.