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 t...
Need Help
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

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

      Anonymous  I'm not sure, where do I go to find that info?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi cmilligan262,

        You can open the 'task manager' and open the 'resource monitor' to simply trice the system resource usage status.
        Regards,

        Xiaoxin Sheng