Share via

Power query error

Anonymous
2022-04-01T15:10:33+00:00

Trying to refresh power query data but keep getting the error 'Excel couldn't refresh the table. Column '134217730' is too large for this instance [SQL_PRODUCT_SHORTNAME_NO_QUOTE] Analysis Services.'

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-01T16:48:18+00:00

    Hi SPW7,

    I go through the post carefully, based on the error, it seems that the issue related to column “134217730” for further troubleshooting, could you please share information below with us?

    1. What is your Office version? Could you please share a screenshot on File>Account page with us?
    2. Do you have column named “134217730” in the data source? If you have, could you please share more details on the column with us?
    3. Have you changed anything before the issue?

    Thanks for your patience.

    Best Regards,

    Clark

    Was this answer helpful?

    0 comments