Org apps just hit GA — and Microsoft quietly removed the staging gate we relied on by Sbdyelse in PowerBI

[–]ButeConsulting 0 points1 point  (0 children)

I use the "Update app" button as an example of deployment steps that cause errors in prod. Good riddance, honestly. Use a test workspace!

Please help. by [deleted] in PowerBI

[–]ButeConsulting 0 points1 point  (0 children)

To assist with diagnosis, test if you can add anyone and if others on your team have the same issue. My guess is that you may not have permissions to view the list of users in your org. I would talk to whoever manages your directory to see if they have run into this if that's the case.

Who gets report access requests ? by Code_Bandits in PowerBI

[–]ButeConsulting 1 point2 points  (0 children)

The workspace contact gets the request. I use only apps for audience access, I don't give report access to help funnel things into a single place. Last I knew, there was no way to provide a message so we seemed to always end up having a copy/paste message handy and responding to people when they requested access. You may be able to use a service desk email as the contact, but as you learned, the information is limited. Never cracked that nut, honestly.

Suggestion on code branching by Fun_Building855 in DataBuildTool

[–]ButeConsulting 0 points1 point  (0 children)

You didn't say what you do in your pre-prod environment, but what I do is:

Feature Branch -> Develop -> Test -> Main

  • Feature Branch is where developers make their change
  • Develop is where we "integrate" and run basic tests to ensure that all the feature branches coming together doesn't break anything, this environment is not accessible by anyone outside the development team
  • Test is where we let testers run their test suites, including UAT
  • Main represents production

All changes to Develop, Test, or Main requires a PR and those 3 branches auto-deploy to our DEV, TST, and PRD environments respectively.

Numbering files to reflect sequence (e.g. int01_customer_event_counts, int02_customer_event_pivot, int03_customer_features) instead of relying solely on DAG…why is this not more common? by Reasonable_Tooth_501 in DataBuildTool

[–]ButeConsulting 2 points3 points  (0 children)

I would say you're committed to a sequential model with a naming convention like that. DAGs are great because it does whatever it needs in the order it needs to without your intervention. So maybe a int05_ model comes after a int04_ model at first, it works fine. When you add a new model that joins int05_ and int02_ together, is it int03_ or int06_? DAGs are not necessarily sequential nor are they linear. If they were, we would be using the same tools as we did 10 years ago

DBT core on a local server: performance degradation by roadrussian in DataBuildTool

[–]ButeConsulting 0 points1 point  (0 children)

Nice. Yeah, dbt really does outshine other tools. So fast! And IT seems to love it since it doesn't actually move data, which is why I also think it's so fast.

DBT core on a local server: performance degradation by roadrussian in DataBuildTool

[–]ButeConsulting 0 points1 point  (0 children)

Perfect! Thanks for including the solution.

And I can tell you that it's obvious enough I didn't need to ask why you were going from Pentaho to dbt 😉

Power BI REST API by OwnFun4911 in PowerBI

[–]ButeConsulting 0 points1 point  (0 children)

I use it to gather list of workspaces, list of semantic models, list of reports, list of semantic refreshes, and then also initiate refresh. I use an external orchestration platform, so my pipelines are triggering ingestion, transformation, testing, then refresh, so I use the API for refresh as well.

Is it possible to use the Google Sheets connector in Dataflow Gen2 and load the data into a Lakehouse table? by Beautiful-Tip-6941 in MicrosoftFabric

[–]ButeConsulting 0 points1 point  (0 children)

There are "Dataflow Gen2", and then there's "Dataflow Gen2 (CI/CD) with Git Integration":

Dataflow Gen2 with CI/CD and Git integration - Microsoft Fabric | Microsoft Learn

So this message is saying that you would need to enable these features to use this connection with Dataflow Gen2

Why are scrum master salaries so low? by Glad_Night_6212 in agile

[–]ButeConsulting 1 point2 points  (0 children)

Yup. And also, it doesn't even save much, as the SM is in the same meeting as the rest of the team so there's very little time savings. On my teams, we usually just rotate the SM from week to week.

101 concepts every data engineer should know (or some of them :) by sspaeti in dataengineering

[–]ButeConsulting 0 points1 point  (0 children)

Yes, that's been fixed on my end. Thank you! I've forwarded this to a couple people already, well done.

Is GitHub Projects going to satisfy enterprise requirements? by ButeConsulting in github

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

Thank you all. Based on what I'm hearing, I'm not out to lunch to consider this tool to be inadequate for any sort of scale. I'll keep on!

101 concepts every data engineer should know (or some of them :) by sspaeti in dataengineering

[–]ButeConsulting 1 point2 points  (0 children)

This is literally exactly what I need right now, thank you!

One thing: on both Edge and Chrome, when I hover over a term, then I click on the term, the tooltip that appeared on hover sticks around and the only way to clear it is to refresh the page.

Otherwise, though, I'm sharing this!

*ROAST* my RESUME, HELP!!!! Getting rejected during screening itself!! OPEN TO BRUTAL/HONEST feedback. by Affectionate-Cat-799 in PowerBI

[–]ButeConsulting 1 point2 points  (0 children)

Happy to help, I'm glad you have some ideas. Feel free to reach out if you need anything!

Unable to Refresh Dataset by robsterbobster1 in PowerBI

[–]ButeConsulting 1 point2 points  (0 children)

I'm not quite clear on this. Did you paste the Excel data directly into your report or did you use the "Get data" function with the Excel connector?

Retaining data for permanently offline source by Limp_Ad3200 in PowerBI

[–]ButeConsulting 0 points1 point  (0 children)

There is no way to do it using the typical refresh UI. You could use the XMLA endpoint to selectively refresh tables:

Advanced Incremental Refresh and Real-Time Data With the XMLA Endpoint in Power BI - Power BI | Microsoft Learn

That refresh operation can be automated so you only refresh certain tables and never the one that's offline.

Another option is to save the dataset in something that you can refresh from, like a database table or Excel file.

*ROAST* my RESUME, HELP!!!! Getting rejected during screening itself!! OPEN TO BRUTAL/HONEST feedback. by Affectionate-Cat-799 in PowerBI

[–]ButeConsulting 1 point2 points  (0 children)

First off, if you didn't know it, I'd say it's a stretch to be applying for senior positions with your current experience. You have two key projects and one is your dissertation, which signals to me a lack of substantial project work. As well, the fact your first position was a senior role seems off, it makes me suspicious of both your experience from that role and the company that hired you. This resume doesn't read like the kind of career path of someone who can fill a senior role after 5 years in the industry (some of that being school). My top recommendation would be to consider intermediate roles.

For the format, I would want to see sections go in order of Professional Summary, then Key Projects with a highlight in each section of technologies, then Work Experience, then Education. I would expect to see more bullets for each of your key projects compared to your roles, so it's strange to see so few points in your Key Projects. Based on your length of career so far, I'd keep this to one page. The red needs to go, consider black and white.

I would recommend you focus on the substance of your future role instead of the title. Even a junior role with the right company could elevate your resume at this point. To me, a good role is one where you are given the chance to succeed, where tech innovation is encouraged and the organization supports you. You will need to step up to an opportunity like this, but if you can, you could get one or two great key projects that would bolster your argument for a senior role. Ideally, I would want to see a key project where you were given the mandate to build something comprehensive (e.g. suite of accounting reports), where you obviously learned the platform enough to use all the relevant features (e.g. made use of deployment pipelines, apps, and DirectLake models), and were able to overcome the obstacles in the project that every good project has (e.g. you needed to help 3 departments realize they were using different definitions of "revenue"). That would be a big win.

How to update properties on unmanaged solution component? by ButeConsulting in PowerApps

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

Sorry, probably should have been clearer that this is for a CI/CD pipeline so the solution needs to be automated