use Tableau.  yeah, just kidding. kind of.

Use Drill Through. I'm pretty sure Patrick LeBlanc (GuyInACube, Freeze) did a video on it and it's on YouTube somewhere.

there are videos all over on YouTube. You need drillthrough.  Pretty sure Adam and Patrick have several videos about it. Search for GuyInACube.

A table with that many columns makes me wonder what the table is describing. it's hard to imagine storing that many bits of information about each instance of a thing....

Why not a simple .NET form to insert into a SQL Server table?

that's an odd request. Did you create a stored procedure to transform the table somehow? Could you post the SQL for it? I'm asking because you don't need SSRS for...

I want to calculate the percentage and aggregate only if the percentage is => 75%

You have to use FILTER() for that, because that's the only way to filter a table...

LAG() basically does what you're describing - goes back N rows in the window.

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, 6 months ago by pietlinden.