fchukoskie Tracker

Re: How to deal with errors on dates?

fchukoskie — Tue, 03 May 2016 15:34:02 GMT

I could be wrong, but that looks like you're translating from mm/dd/yyyy instead of dd/mm/yyyy to me.

Re: Show top n entries

fchukoskie — Mon, 21 Mar 2016 18:22:36 GMT

Leiterfluid wrote:
...
RANKX has proven useless for me in a situation where I have over 200,000 rows in my dimension table against a 600,000 row fact table. Even a beefy Alienware laptop with 32 GB RAM could not process the measure.

...

For a bit, I thought maybe it was just me. Misery loves company, though. Thanks!

Re: Ability to adjust column width inside table in Power BI Designer

fchukoskie — Wed, 24 Feb 2016 15:57:58 GMT

Is Desktop version 2.3.1.4280.661 (64-bit) not yet GA?

(disregard...our chart had a white-on-white column border that made it hard to find for resizing)

HarrisMalik wrote:
Column width adjustment will be available in GA. You can already see it working. Just create a visualization using Q&A on Powerbi.com that will give you control over new GUI, change the visualization to table or matrix and try to change the column width.

Cheers

Re: PBIX file corrupted

fchukoskie — Fri, 19 Feb 2016 14:15:57 GMT

No luck with WinRar or any of the other .zip repair tools that I've tried. Glad it got you out of the weeds, though. Good tip to try, should it happen again. Thanks!

Re: PBIX file corrupted

fchukoskie — Thu, 18 Feb 2016 15:35:11 GMT

Yeah, I've been in that situation (keep multiple backups) with other tools when they were in their early stages, but I'm out of practice. Guess what's old is new again.

If it sheds any light on the problem, when I copied the .pbix to a .zip file, the "DataMashup" file was the one that Windows reported as corrupt...but excluding it from a new .zip archive didn't save me either.

Back to square 1.

Re: PBIX file corrupted

fchukoskie — Thu, 18 Feb 2016 13:57:59 GMT

If misery loves company, it got me today too.

Re: Drill down and filter

fchukoskie — Fri, 05 Feb 2016 17:22:12 GMT

I'd expect to see the breakdown by Subject where Rating = 1 and Answer = 'It's not helping me'.

Re: Drill down and filter

fchukoskie — Thu, 04 Feb 2016 21:04:14 GMT

Yes on the release question. Version: 2.31.4280.361 64-bit (January, 2016)

Thanks for fact-checking me. I'm new enough to the tool that I don't yet have a sense for what's a bug and what's self-inflicted.

-Frank

Drill down and filter

fchukoskie — Thu, 04 Feb 2016 20:19:02 GMT

In a Power BI desktop stacked bar chart, I'd like to drill-down by clicking to see which 2nd-level items (Subjects) make up the 94 replies in a survey. However, that double-click renders the entire chart at the subject level...showing all replies, instead of just the 94 that I'm interested in.

Is this sort of drill-and-filter clicking possible, or do I have to drill first, and then apply a filter to the right of the chart?

Re: Star Schema cross-join

fchukoskie — Mon, 18 Jan 2016 17:22:43 GMT

greggyb It made perfect sense, thanks. Long-term, it's looking like a good fit for the times when I want something like QlikView, but less so for the times when I need MicroStrategy/Cognos ROLAP like behavior.

Re: Star Schema cross-join

fchukoskie — Mon, 18 Jan 2016 16:51:29 GMT

Fair question on requirements, but I'm really making this up as I go. We're still getting data cleansed & standardized in an Azure SQL Data Warehouse, so I'm trying to evaluate options on BI & Reporting tools in parallel as time allows...which means that there was no requirement for matrices of data. It was just what I was doing that day while exploring options for self-service BI that might mimic what we could get from ROLAP tools like MicroStrategy or Cognos.

Re: Star Schema cross-join

fchukoskie — Wed, 13 Jan 2016 17:58:42 GMT

Disappointing, but that's reality sometimes. Thanks.

(maybe someday...)

https://ideas.powerbi.com/forums/265200-power-bi/suggestions/11434623-allow-bi-directional-filtering-for-directquery-rep

Re: Star Schema cross-join

fchukoskie — Wed, 13 Jan 2016 17:39:56 GMT

Using the key field as an example was contrived. I really want to attributes from the dimension table in a star schema. If we can't, we'll just have to start authoring views to flatten everything (at which point, we probably pick a different tool).

As to the filter, how do I enable that for tweaking so that we can pick "bi-directional"?

Re: Star Schema cross-join

fchukoskie — Wed, 13 Jan 2016 17:18:32 GMT

It's not Azure. Here's a sample matrix created from a DirectQuery against AdventureWorksDW.

Count (Distinct) of FactInternetSales.CustomerKey:

Count (Distinct) of DimCustomer.CustomerKey:

Here's the model:

Star Schema cross-join

fchukoskie — Wed, 13 Jan 2016 15:17:15 GMT

I'm creating my first PowerBI dashboard, using DirectQuery against an Azure SQL Data Warehouse instance, and am seeing strange cross-joins.

When I add 1 fact table and 2 dimensions to the model and test counts in a simple matrix, creating a "Count Distinct" measure on one of my key fields (a join key between the Fact & Dimension table) works as expected (though slowly) if I pull that field onto the matrix from the Fact table. So, it should be asking SQL for a distinct count of "fact.userid".

However I pull that same field onto the matrix from the Dimension table (dimension.userid), the Count Distinct looks like it's cross-joining to the other dimensions in the matrix (in this case, "Month" from the calendar dimension). Subsequent tests then show that any field from that dimension also cross-joins in the matrix.

The relationships to each dimension show as "Active" under the "Manage Relationships" table, but I can't figure out if there's a way to see the SQL that PowerBI sends to Azure in its DirectQuery to understand why it's counting incorrectly.

Am I handling the relationships wrong, or does PowerBI expect the model to be more "flat" for DirectQuery to work?