December 23, 2024 at 2:56 am
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!
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply