+ Reply to Thread
Results 1 to 4 of 4

Power Query SQL connections - password saved with file?

  1. 08-06-2021, 02:12 AM #1
    zico8
    zico8 is offline
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    Power Query SQL connections - password saved with file?

    Hi,

    I have created some files that get data from SQL Server Database by Power Query.
    I need to share these files to my colleagues.

    How can I set credentials so they will not be prompted about it? Maybe somewhere inside macro?

    I have only refreshing event during opening file (ThisWorkbook.Connections("Query - MyQueryName").Refresh)
    Reply With QuoteRegister To Reply
  2. 08-06-2021, 02:35 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,300

    Re: Power Query SQL connections - password saved with file?

    Is your profile up-to-date? Are you still using Excel 2010?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-06-2021, 03:35 AM #3
    zico8
    zico8 is offline
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    Re: Power Query SQL connections - password saved with file?

    Office 365.
    Do you know solution to my question?
    Reply With QuoteRegister To Reply
  4. 12-01-2021, 04:58 AM #4
    zico8
    zico8 is offline
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    Re: Power Query SQL connections - password saved with file?

    Anybody can help?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power Query Connections and Data Validation
    By AllisterB in forum Excel General
    Replies: 1
    Last Post: 04-30-2021, 06:28 AM
  2. [SOLVED] Difference between connections and queries using VBA to create Power Query
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2021, 05:57 AM
  3. [SOLVED] delete power query connections for the copy workbook
    By bujaber10 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2020, 04:30 PM
  4. [SOLVED] Use VBA to remove all power query connections with DocumentInspector
    By beaglesBuddy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2018, 05:17 PM
  5. Power Query / Get & Transform - new exports > new connections
    By SHI.NL in forum Excel General
    Replies: 3
    Last Post: 04-20-2018, 08:30 AM
  6. Does My VBA Code To Refresh CSV Power Query Connections Need To Change for MySQL Queries?
    By beaglesBuddy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2017, 02:57 PM
  7. Power Query - Storing and Connections
    By James McEwan in forum Excel General
    Replies: 0
    Last Post: 08-09-2016, 08:19 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1