+ Reply to Thread
Results 1 to 9 of 9

error in power query & power pivot

  1. #1
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    error in power query & power pivot

    Hi,
    i am new to power query and power pivot, i am using excel 2016 and got the following error when trying to combine two tables in query from table in data tab.

    "we couldn't get data from the data model, here is the error message we got; No error message available, result code : -2146233052(0x80131524)".

    I tried a lot but not found any power table add-in in excel 2016. there is only one com Add-ins available that is Microsoft Power Map for excel.

    Power pivot is working but Calculated fields are not working and become grayed.

    Please help

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: error in power query & power pivot

    Hi,

    In 2016 Power Query is called Get and Transform and is built in to the product. If you do not have a ProPlus or standalone edition of Excel, you will not have Power Pivot available to you- and you cannot download it separately.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    Re: error in power query & power pivot

    Thanks for quick reply

  4. #4
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    Re: error in power query & power pivot

    Get and Transform is available in my excel, i am using Microsoft excel standard 2016

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: error in power query & power pivot

    Indeed- as I said "In 2016 Power Query is called Get and Transform and is built in to the product"

  6. #6
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    Re: error in power query & power pivot

    Untitled.jpg

    Getting attached error

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: error in power query & power pivot

    What exactly were you doing when you encountered the error? It appears from your screenshot that the first table has not loaded into the data model, but I cannot tell you why from a picture.

  8. #8
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    Re: error in power query & power pivot

    Step:
    1. selecting table one
    2.clicked on Get and trasform "from table"
    3. Query editor get opened
    4. in query editor clicked on close & Load to
    5. Dialog box appear "Load to"
    6. check boxes "Only create connection" & "New worksheet" & "add this to data model' selected
    7. error message appeared
    Last edited by Baldev Kumar; 02-20-2017 at 04:58 AM.

  9. #9
    Registered User
    Join Date
    10-16-2017
    Location
    HK
    MS-Off Ver
    2010
    Posts
    3

    Re: error in power query & power pivot

    i encountered the same problem in my pc............no solution at all
    But some pc didn't have that problem.
    Might be compatibility problem..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 10-25-2016, 02:59 AM
  2. Power Query, Pivot, View and Map
    By olasa in forum Suggestions for Improvement
    Replies: 4
    Last Post: 07-20-2016, 08:14 AM
  3. Run-Time Error Caused by Power Query??
    By phelbin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2016, 01:12 PM
  4. Power Query MySQL Database error
    By brent_milne in forum Excel General
    Replies: 0
    Last Post: 08-21-2015, 11:21 AM
  5. Simple SQL Query in Power Pivot
    By zicitron in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-30-2014, 12:42 PM
  6. Power Pivot Error
    By manoshet in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-24-2014, 04:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1