cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rcalvo Frequent Visitor
Frequent Visitor

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

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

 

 

Power BI Error.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
rcalvo Frequent Visitor
Frequent Visitor

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

@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!

 

 

View solution in original post

7 REPLIES 7
BhaveshPatel Super Contributor
Super Contributor

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

It seems like you are running out of the memory!

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
rcalvo Frequent Visitor
Frequent Visitor

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

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

 

Power BI Error.jpg

BhaveshPatel Super Contributor
Super Contributor

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

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.

 

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
rcalvo Frequent Visitor
Frequent Visitor

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

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

Moderator v-yuezhe-msft
Moderator

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

Hi @rcalvo,

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

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rcalvo Frequent Visitor
Frequent Visitor

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

@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!

 

 

View solution in original post

Shiva799 Frequent Visitor
Frequent Visitor

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

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

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 131 members 1,735 guests
Please welcome our newest community members: