Post reply

Automating Export of PowerQuery to SQL Server using DAX Studio...?

  • December 23, 2024 at 2:56 am

    #4503376

    I wrote a PowerQuery that parses a table from a PDF, and I want to export it to SQL Server. I tried using the PowerQuery source in SSIS, and it wouldn't let me map the columns. (Maybe I did it wrong???) I got DAX Studio to export the result of the PowerQuery to SQL Server, but I wanted to automate it.  Can I automate DAX Studio using SSIS or something that I can schedule?  The basic idea is to put all the PDF files into a folder and then let something like SSIS to loop over the folder's contents, and then parse the table in the PDF using PowerQuery and then dump the results into SQL Server.

    I can do it manually, but I can't figure out how to automate DAX Studio. Is it possible and I'm just missing it?

    As you can tell from my description, I'm sooo confused! Feels like this should work, but I have no clue how to automate DAX Studio. I looked at Export in the documentation, but there's no mention of it. Here's the page that explains Export:

    But there's almost nothing there, and no mention of automation of Export either. Or can I now use SSIS to do this? The last time I tried it, I couldn't map the source columns to destination columns (the column names just didn't appear at all).

    I found this link that shows how to do this in Fabric, but I'm just using PowerBI Desktop. And they're suggesting using Python? I could do that, but wow. Talk about a patchwork answer to a really simple question!

    • This topic was modified 5 months ago by pietlinden.
    • This topic was modified 5 months ago by pietlinden.

  • December 24, 2024 at 3:09 am

    #4503875

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • December 26, 2024 at 7:48 am

    #4505060

    I'm away from a proper PC at the moment, so could not come up with any possibilities. But as you make no mention of DAX in your post, is there a reason for using DAX Studio rather than some other tool that can run PQ?

  • December 26, 2024 at 7:23 pm

    #4505311

    I was basically just playing with DAX Studio when I discovered it could export the result of my PowerQuery.

    I suppose I could just copy and paste my PowerQuery into Excel and run everything from there, and then send that to SQL Server....

    Would be nice if I could do it in SSIS and then just do the standard For Each file Loop and then if something fails, send it to a different folder.

  • December 27, 2024 at 4:30 am

    #4505487

    A thousand years ago, I tried doing this in SSIS, but the PowerQuery source works like... well, not at all. =(

    Here's the beginning of the conversation: SSIS task that runs a PowerQuery – SQLServerCentral Forums

     

    • This reply was modified 5 months ago by pietlinden.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy