+ Reply to Thread
Results 1 to 2 of 2

PowerQuery

  1. #1
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    546

    PowerQuery

    I don't know if this is appropriate for here but does anyone have any experience with PowerQuery.
    I would like to connect to a SQL database and build reports. I dont know SQL language so maybe PowerQuery might help.

    I would like to be able to directly build the report or extract right in excel so I can automate certain processes. Rather than using a secondary system to extract the data..manipulate it and then paste it into excel

    Is powerquery the way to go? Any comments would be appreciated.

    Thank you.

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

    Re: PowerQuery

    PowerQuery in combination with PowerPivot can handle most reporting needs and will be able to connect most db out there.

    If you need more custom visuals, publish report to secure web etc... then you may want to look into PowerBI (Pro subscription, but you can start with free Desktop application).
    It uses same query engine as PowerQuery and PowerPivot (with some additional features as R/Python integration, visual customization etc).

    With PowerQuery, you can bring in SQL table as is with relationship column(s)/tables and transform it using GUI and M query language.
    However, I'd recommend learning basics of SQL query, for performance reasons.

    Some links for learning basics:
    https://support.office.com/en-us/art...7-d3da689091b5
    https://radacad.com/tutorial-introdu...to-power-query
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. PowerQuery in Excel: Use an Excel table to populate SQL table in PowerQuery
    By joeyslaptop in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-25-2019, 02:33 PM
  2. [SOLVED] How to replicated an IF formulan in PowerQuery
    By orhanceliloglu in forum Excel General
    Replies: 10
    Last Post: 08-08-2018, 03:56 AM
  3. PowerQuery Many 2 Many Relationships
    By rabbit_post in forum Excel General
    Replies: 1
    Last Post: 02-01-2018, 05:17 PM
  4. Unpivot with PowerQuery possible?
    By nobodyukno in forum Excel General
    Replies: 3
    Last Post: 08-23-2017, 03:34 PM
  5. VBA vs PowerQuery
    By Trachr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2017, 11:50 PM
  6. PowerQuery and VBA
    By Trachr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2017, 12:10 AM
  7. Help with powerquery.
    By stephme55 in forum Excel General
    Replies: 0
    Last Post: 09-01-2016, 07:31 PM

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