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!

     

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

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'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