Forum Discussion

rcalvo's avatar
rcalvo
Frequent Visitor
9 years ago
Solved

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 creat...
Need Help
  • rcalvo's avatar
    rcalvo
    9 years ago

    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!

     

     

rcalvo's avatar
rcalvo
Frequent Visitor
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi rcalvo,

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


Thanks,
Lydia Zhang

  • rcalvo's avatar
    rcalvo
    Frequent Visitor
    9 years ago

    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!

     

     

    • BT76's avatar
      BT76
      New Member
      3 years ago

      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.

  • Shiva799's avatar
    Shiva799
    Frequent Visitor
    8 years ago

    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