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 1 year, 11 months 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 1 year, 11 months 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 1 year, 11 months 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 1 year, 11 months ago by pietlinden.

Oh, sorry. Left a lot of stuff out.  The files are getting imported into PowerBI (not in Fabric, or whatever MSFT calls it these days), and they do all the...

• This reply was modified 1 year, 11 months ago by pietlinden.

Okay, silly me... I completely missed Reza Rad's video on it, "Aggregation to speed up the performance of a Power BI report even if all IMPORTED"

You basically create an...

if all else fails, read the manual:

pandas.DataFrame.mean — pandas 2.1.1 documentation (pydata.org)

In particular, the diagnosis and procedure dimensions could be handled as a multi-valued dimension

How do you mean? Could you give an example of "a diagnosis being handled as a multi-valued...