If an account can access both of the instances, you could do something like inserting the results from one call (but include the database name), and then the other call,...

If your data is in tables in the PDF file, you can tell PowerQuery to return just the table. Is this a publicly available PDF file? (likely not)... I wanted...

If I just use a PowerQuery inside my data flow, I can just read the table and tell PowerQuery to ignore the rest. Then it's stupid easy. No need to...

Come to think of it, if they paid for like 3 months of an Azure subscription, they could dump whatever they wanted there, and we could use pipelines in Data...

Not meaning to hijack this thread, but I can read PDF files and parse the stuff I need out of them using PowerQuery.  Can I call a PowerQuery "script" in...

The tables that measures are assigned to/stored in is irrelevant to their function/calculation.  In PowerBI at least, you can move them wherever you want. I would assume the same is...

Since I'm in the testing time (30 days or whatever) for Azure, I could maybe upload my data and do it all there.  One of the fact tables feels crazy...

Can't find it now... there's this one: Import Power BI Desktop Model to SSAS Tabular 2016 (biinsight.com)

Feels a lot like MSFT really doesn't want you to do that. talk...

• This reply was modified 2 years ago by pietlinden.

Oh, cool!

Thanks Eddie!

I may be sorted... I have to patch up my format file and then I can just do this to move my data from BLOB storage to my...

That's what the CROSS APPLY basically does.  Test out the code I wrote to see if it accomplishes what you need.  It basically converts all the values in the comma-delimited...

Okay, here's my solution assuming you can't modify the table. Sometimes you just have to live with a bad design. If the table is really big, it might be worth...

So all you want to do is copy the table name and the number of records into a table? Why not query the  system tables? Sort of like this:

            
November 15, 2023 at 8:01 am
            
#4327862

            
            
                                                
        

Oh, owww... Normalization is your friend.  You should read Jeff Moden's article on his function DelimitedSplit8K

basically, you have to create the function in a database somewhere. (I'm in TempDB...

• This reply was modified 2 years ago by pietlinden. Reason: "Answer the question, Claire!"

Okay, I'm working on a smaller copy (just the top like 1000 rows), and it's working except everything is imported delimited by double quotes. (Nice and fast though...) After that...

• This reply was modified 2 years ago by pietlinden.

Can I do the whole import without using the Wizard, which creates (I think) and SSIS task? Because that crashes with Out of Memory errors?

For grins, (and because I'm used...

• This reply was modified 2 years ago by pietlinden.