Forum Discussion

cmilligan262's avatar
cmilligan262
Icon for Helper II rankHelper II
5 years ago

OLE DB or ODBC Error: Resource Governing

I'm trying to create a composite model where I union and summarize two different Power BI datasets to create a single table. While testing and working on summarizing one of the datasets I'm getting this error when summing the amounts. Is there anything I can do to resolve this?

 

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    cmilligan262 , is it in power bi service or desktop?

     

    In desktop, you can  try increasing data memory cache in data load under option

     

    file -> options and setting

    • cmilligan262's avatar
      cmilligan262
      Icon for Helper II rankHelper II
      5 years ago

      I'm on desktop. I increased to 10,000 and am still gettting the same error. Is there a recommended number based on the data you're pulling in?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI cmilligan262,

        How many idle memory resource that existed in your device? If you increase the size limit without enough resources, these settings should not work.

        Regards,

        Xiaoxin Sheng