+ Reply to Thread
Results 1 to 2 of 2

Power Query "add this data do data model" refresh issue

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    Poland
    MS-Off Ver
    2013
    Posts
    87

    Power Query "add this data do data model" refresh issue

    Hi Experts,

    I have a query build in PQ from several workbooks. When I save the query as connection I can't refresh it. The only way to do so is to mark "Add this data to data model" when choosing Load to options. My version on Excel is 15.0.4885.1000, 32 bit and PQ 2.38.4491.181.

    Thanks for any help !

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,750

    Re: Power Query "add this data do data model" refresh issue

    Since it's only connection and data isn't loaded anywhere, it's expected behaviour.

    Either load data to model or load to table. You can then refresh.

    Alternately, you can go into Query Editor and refresh preview in there.

+ 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: 6
    Last Post: 02-17-2017, 08:31 AM
  2. Replies: 7
    Last Post: 11-08-2015, 03:57 PM
  3. Disable "Query Refresh" prompt
    By pdmkh in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-28-2009, 04:20 PM
  4. Replies: 0
    Last Post: 04-10-2006, 05:50 PM
  5. Suppress "Disable/Enable Macros" and Query Refresh dialog on open
    By Sharon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2006, 05:25 PM
  6. Replies: 0
    Last Post: 01-04-2006, 11:35 AM
  7. "Query Refresh" Enable or Disable popup...how do i get rid of it!
    By dark86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2005, 11:31 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