u/annoyingbrokeguy

Dataflow Gen2

i have three helper queries: 2 sourced from excel files, one sourced from csv, all saved on sharepoint

i have three separate queries for each of the different sources and am then appending them all into the fact table to be used.

output is to lakehouse

the individual helper queries seem to output ok but the combined query is failing. it gives a generic mashup error each time and I’ve tried to refresh this multiple times

final dataset is expected to be around 5million rows and around 20 columns.

has anyone else encountered this / has a fix?

i guess im spoiled by Amazon but bought some stuff a few days ago and still not shipped yet. was hoping to have it by July 1st since im going on vac after but at this point may not be feasible

im in the northeast so assuming its coming from MA then I should be ok with a day or two once its handed to courier.

As title says, I have a report where currently I need RLS on at least two dimensions. Lets just say one dimension is Location and the other Dimension is Product.

there are multiple hierachy levels in both dimensions

location would be Continent > Country > State > City

Product would also have multi levels

The requirements are:

users that will see everything

users that will see all productions but security on location

users that see all location but security on product

users that will have mix of security on both location and product.

emails and permissions to be stored in excel on sharepoint. is there a way to set this up so I’m not putting an email across everything at the lowest levels?

I have the following fields:

• Reporting Date (connected to date table)
• As of Date
• Cost Center
• GL Account
• Amount

As of Date will vary by cost center, some may have more than others. what I need to do is to calculate the sum by cost center and GL account for the reporting date based on the latest as of date for that reporting date period.

as an example, cost center 123456 may have 5/15/26 and 5/20/26 in the as of date field for reporting date 5/31/26. I want a measure to show the balances as of 5/20/26

i tried doing measure below but it is summing all of the As of Dates as opposed to largest.

how can I adjust the measure so it will reflect correct values?

Measure =

Var _MaxAsOfDate=Max(‘Table’[As of Date])

return Calculate(Sum(‘Table’[Amount]), ‘Table’[As of Date]=_MaxAsOfDate)

background:

took current role a year and a few months ago since it’s a 40% increase in comp.

from the start, I can tell manager is unorganized but figured I can work with it. since then, continues to be unorganized even though I’ve said if we make the effort now to be organized it’s a lot better end to end (I’m talking things like file naming convention, notes on projects, etc etc). the bigger issue is he’s not kept me in the loop on anything. any senior exec time he does (even if I did the work). I specifically mentioned he can do better in exposing me to senior mgmt and per him he’s doing best he can (no instance in the 1 year plus ive been here). there are instances where he’s coming to me for ideas and then playing it off as his own, and then comes back to me as if he originated the idea…other issues are bc he keeps me in the dark there are certain things that would’ve been nice to know beforehand to better plan for but now we have to do an ad hoc interim fix since he’s not communicated anything.

the issue is I don’t have as much flex within the team (going back to him keeping me siloed and no exposure) so it’s a bit risky to complain to skip level even if I have valid concerns. manager has me (sr mgr) and a SFA as a direct report and SFA has also voiced same frustrations to me.

thoughts/opinions on next potential moves? external postings are slim even if i stay at current comp. internal - no postings from the team and if there is movement we’re likely hiring a level lower. manager was also on the same team at his old company for 20+ years so I don’t anticipate him moving internally and me getting out that way.

background:

took current role a year and a few months ago since it’s a 40% increase in comp.

from the start, I can tell manager is unorganized but figured I can work with it. since then, continues to be unorganized even though I’ve said if we make the effort now to be organized it’s a lot better end to end (I’m talking things like file naming convention, notes on projects, etc etc). the bigger issue is he’s not kept me in the loop on anything. any senior exec time he does (even if I did the work). I specifically mentioned he can do better in exposing me to senior mgmt and per him he’s doing best he can (no instance in the 1 year plus ive been here). there are instances where he’s coming to me for ideas and then playing it off as his own, and then comes back to me as if he originated the idea…other issues are bc he keeps me in the dark there are certain things that would’ve been nice to know beforehand to better plan for but now we have to do an ad hoc interim fix since he’s not communicated anything.

the issue is I don’t have as much flex within the team (going back to him keeping me siloed and no exposure) so it’s a bit risky to complain to skip level even if I have valid concerns. manager has me (sr mgr) and a SFA as a direct report and SFA has also voiced same frustrations to me.

thoughts/opinions on next potential moves? external postings are slim even if i stay at current comp. internal - no postings from the team and if there is movement we’re likely hiring a level lower. manager was also on the same team at his old company for 20+ years so I don’t anticipate him moving internally and me getting out that way.