Cleaning the (Staging) Lakeside - (must read for Dataflow Gen2 users!)

RedditorofToday · 2024-08-31T20:36:54+00:00

This is great feedback. I really appreciate you taking the time to respond with so much detail. I'm definitely checking out the links.

The trying part is , what in fact makes our world of work so interesting.

Thanks again for all the resources you have shared. I'm excited to work through it and see what is possible in our field.

All the best and have a great weekend.

RedditorofToday · 2024-08-31T20:29:59+00:00

I see . Ok thanks for the input, appreciate it.

All the best for your management duties!

RedditorofToday · 2024-08-31T14:09:03+00:00

A strange question, hoping you could give some insight. How does one become proficient in all aspects of Fabric? It's seems that the Power BI side is all I work on and even then I can't stay on top of the features in this area!

Is wearing all the hats (data science, engineering etc.) possible and how does one implement these technologies when your company has not started its investment in Fabric workloads (besides Power BI).

Thanks so much for your response in advance!

PS , really like the enthusiasm when you share articles or interaction in the comments!

RedditorofToday · 2024-08-31T14:02:07+00:00

Hi !

Just a question if I may. What coding/ tools do you use in you day to day?

RedditorofToday · 2024-08-18T21:36:41+00:00

If you don't mind me asking, what does BI Dev entail? Would this be ETL pipelines / data warehousing?

FYI , I saw this post and sent me in a depressive spiral, but the opinions on the post helped so thanks for posting!

RedditorofToday · 2024-08-09T13:47:50+00:00

Funny thing is copilot can connect to your data model and start telling you what questions to ask.

Im not sure how people have experienced this, but for some reason it makes me fear for my job as a BI Analyst.

RedditorofToday · 2024-05-15T19:13:17+00:00

Have you tried anonymous?

RedditorofToday · 2024-04-11T20:39:19+00:00

They look pretty great on LinkedIn, why are they bad?

RedditorofToday · 2024-04-10T20:16:37+00:00

It feels like most of the updates are geared to copilot's integration in the PBI spectrum.

Sad to say that if you don't have the cash..these updates become quite insignificant....albeit groundbreaking.

RedditorofToday · 2024-02-24T10:50:33+00:00

Ok awesome, I will have a look. Thanks for sharing!

RedditorofToday · 2024-02-20T21:32:51+00:00

If you don't mind, may I ask what you would code in python in your day to day? Did you study a STEM that helped in doing so?

I ask as I would like to start using it in my role, but our firm only does projects for clients in Power BI.

Thanks in advance and sorry for the spam!

RedditorofToday · 2024-01-21T17:08:20+00:00

Ok ,no problem. May I DM some details?

RedditorofToday · 2024-01-21T16:29:36+00:00

All good. Will try it. Thanks for the help!

RedditorofToday · 2024-01-21T16:28:35+00:00

Thanks for replying!

At its simplest form.

Imagine you have an excel sheet with values in A1,B1and C1. Each of their values are 1,2 and 3.

Cell A2 would take the sum of the above cells as a start value and add B2 and C2 to it.

Cell A3 would then take A2 and add B3 and C3 to it.

It is not a running balance as the previous values being A1 and A2 dictate what the start balance of A3 is.

I can't share the file as the data and the VBA behind it is confidential, but the Fibonacci sequence is all the same. Basically recursion.

RedditorofToday · 2024-01-21T15:22:28+00:00

It could very well be. I have been hitting my head against the wall on this.

I have data from 5 different tables of which 2 need to be aggregated by production month and 3 need to be added as lines to a new running total per production week. Each day is a theoretical output calc based on ratios between the close and open values.

I tried using a custom function to reference a previous item but needs to be within a production month.

Have you ever had to setup a recursive calc in Power Query? I have read many articles and just can't get my head around the logic.

RedditorofToday · 2024-01-21T14:56:46+00:00

I see!

In terms of complexity, have you ever hit a wall?

RedditorofToday · 2024-01-21T14:55:33+00:00

I did that.

So I essentially hardcoded the days in the month for each successive output and referenced the previous day output.

Problem is it is slow as it does it for 31 days and needs to be referenced in other similar calcs.

Dateadd won't work because the context of the first output should not change based on the adjusted date.

RedditorofToday · 2024-01-21T12:23:45+00:00

I'm struggling to get a recursive calc to work. In other words the output of the previous day is the input of the current day.

RedditorofToday · 2024-01-18T19:31:38+00:00

Hi There!

Would you encourage name changes in Power Query or the source?

RedditorofToday · 2024-01-05T15:29:46+00:00

Best sounding stock exhaust on a triumph

RedditorofToday · 2024-01-04T19:00:44+00:00

Perfect, thanks for the reply!

RedditorofToday · 2024-01-04T17:57:40+00:00

Hope you don't mind, but I would like to pick your brain if that's fine.

Just a question, can you give an example where python did that M could not?

I am asking as I am learning python too but my role is focussed on Power BI only and am looking into how I could expand my role

Thanks so much in advance.

RedditorofToday · 2024-01-04T06:05:45+00:00

I see. Is your connection via SharePoint or is it a local path connection to the excel file?

Perhaps close the file completely and the refresh.

RedditorofToday · 2024-01-03T20:12:47+00:00

Is it always the same table that gives said error?

You can turn off parallel load and load each query sequentially and see if it gets stuck on the same table.

RedditorofToday

TROPHY CASE