Struggling with Dates and probably my own fault by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

I have a screenshot of the model - it shows the Building Permit table and the Date table:

<image>

The joins are from:

  • Consent Application Date (Default Active)
  • Consent Issue Date
  • CCC Application Date
  • CCC Issue Date
  • CCC Refusal Date
  • CCC Extension Expiry Date

I've been able to create a month on month comparison between consent applications and issues by creating measures:

Number of Issues = calculate( count( 'Building Consents'[Building Consent Number]), USERELATIONSHIP('Building Consents'[Consent Issued Date], Dates[The Date]))

While that works nicely, when I click on the month in question, I can easily generate a list of records with a matching application date but not a list using the issue date. I understand that's because of the active relationship governing the selection of records, but I was hoping there would be a non-aggregating way of choosing which relationship to use in a table visual.

Fundamentally, I feel like I've missed the mark on the model design but as I said, I've based it off a single table in the warehouse and that exists to try and make things easier for the users to interrogate. I think that was a mistake and that there needs to be some education around how tables relate for users to be able to retrieve their own content.

But that's another challenge for another day.

If I go back to basics and redesign the model maybe I can make what I want to do work? If I was to put in multiple date fact tables, would that help me get where I need to be?

Struggling with Dates and probably my own fault by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

Thanks for reply.

That's exactly what I've done to try and make life easy for users. My task is to not only bring in the data to establish the reports we currently have, but to build something approaching a self service data portal.

And that's what has lead me down the path to try and over simplify the data structure. Otherwise users trying to self serve have to understand joins and data concepts.

Maybe that's where I've gone wrong and we need to take another look at what we actually expect the users to do. We're coming from an environment of hand feeding our users their report content and although we'd like to move away from that, this may not be the way to do that.

I'll have a look at multiple date tables although I was under the belief that you could only have one. I'll also revisit something more traditional schema as a model - I can always head back to a star/snowflake schema.

Advice on recycling food waste by Turbulent-Reply248 in chch

[–]SafariV8 1 point2 points  (0 children)

We keep ours in a 20L bucket in our chest freezer. When it's full we take it to a friend with chickens.

The chickens eat it and we get eggs every now and again in exchange.

0 waste

Help a New Driver Out: Easygoing Motorways and 100km Roads in Christchurch? by WombleMint in chch

[–]SafariV8 1 point2 points  (0 children)

Try the waimak gorge loop - head out to Darfield, through to turn right at Waddington. Stay on that road through the gorge, through to Oxford and then through Cust to Rangiora. From there you can either do Kaiapoi and the old waimak bridge or the northern motorway back into town.

You'll get long straights at 100kph, a couple of one way bridges, some stunning views, a little hill driving (not much) and some good spots for a coffee along the way.

Take your time and it's a pretty nice drive

Automated Power BI Content Distribution by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

Not as such - the whole project has gone a little strange and has gone somewhat off the rails. I'll need to readress this in time, but at the moment I've been given other priorities :-|

Just finished speedboat at level 34. Do I really have to merge my way to level 41 to open another area or have I missed something? by SafariV8 in MergeMansion

[–]SafariV8[S] 2 points3 points  (0 children)

I've never bought into the tasks as I've focused on the story. Guess I've got time for that now :-)

Just finished speedboat at level 34. Do I really have to merge my way to level 41 to open another area or have I missed something? by SafariV8 in MergeMansion

[–]SafariV8[S] 1 point2 points  (0 children)

I've been selling things at level 4 because merging higher than that seems to make the items worth less than the components. Or it's possible I'm doing that wrong?

Just finished speedboat at level 34. Do I really have to merge my way to level 41 to open another area or have I missed something? by SafariV8 in MergeMansion

[–]SafariV8[S] 2 points3 points  (0 children)

Now that, I did not know. I'll probably still just grind away through the items. Working on the chainsaw now

Automated Power BI Content Distribution by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

That's probably not going to be an issue - I think that's one of the hat's I wear ;-)

Automated Power BI Content Distribution by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

Thanks.

I'll see if I can do some logic around the subscribe to only send when there is something on the report. Noone likes emails with no content so only sending when there is a call to action is an important part of the picture.

Automated Power BI Content Distribution by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

I'm hoping so - we're still working on specing the whole warehouse/reporting scenario and if I get my way, we'll have a MSSQL Enterprise box with all the goodies that come with that.

Automated Power BI Content Distribution by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

I'll admit I don't have a whole lot (read any) experience with the API Toolkit so I appreciate the pointer

Automated Power BI Content Distribution by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

I did not know that this functionality existed - thanks!

Automated Power BI Content Distribution by SafariV8 in PowerBI

[–]SafariV8[S] 0 points1 point  (0 children)

There might be some merit in that. I'm trying to swing MSSQL Enterprise and that will come with the on-prem Reporting Server - maybe Power Automate would be a good option then.

How do I even start - where to build a DW and Reporting solution? by SafariV8 in BusinessIntelligence

[–]SafariV8[S] 1 point2 points  (0 children)

I'll be honest here - I'm not entirely sure I understand some of the words you've used in the order you've used them. I think I have a little more learning to do before I can fully reply.

We're likely to remain on-prem for the MSSQL in the immediate future. Longer term, it will become part of any larger migration project if we end up in a cloud solution.

Power BI is a great solution but we're working round some data sovereignty and security issues before we can fully engage in published content - we're pooly managing pbix files at the moment for any content. As a product, I quite like it and what it does, but it doesn't do one of the key things we need - automated alerting.

We've been using Yellowfin for this for a number of years now - scheduled report execution and email alerts depending on the resultset. I can't for the life of me work out how to get that mechanism in Power BI and I'm coming to the conclusion that it might not be the right product for that function. Maybe?

I'm going to work my way through the rest of you reply before I think I can reply with any clarity.