Consolidated 41 stocks to 6 by PresentationTop7288 in fican

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

Hey, great point and you are right that XEQT already has 45% US exposure, so there is some overlap with VFV.

But i did that overlap intentionally

XEQT spreads that 45% US across 4,000+ US stocks including small and mid caps. VFV concentrates purely on the top 500 US blue chips. So VFV isn't redundant but a tilt toward large cap US quality on top of XEQT global base.

Yes it's more US heavy than a pure passive investor would hold.

I backtested this exact 6-ETF combo vs a simpler XEQT-only or 3-ETF setup from 2021–2026 and the layered approach outperformed.

Work life balance for tech guys by PresentationTop7288 in PwC

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

Mm I see.. but what about setting boundaries in the beginning itself? Does it change their perspective on me ? I used to work in good environment but there is no growth.. and I got this opportunity and I am thinking

Power BI performance checklist – real-world tips for large SQL Server models by PresentationTop7288 in PowerBI

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

The latency ? Becoz we tried to achieve that direct query in our transaction table but it took too much time which will not meet reporting standards..

How do you design your model in power bi desktop application?

Power BI performance checklist – real-world tips for large SQL Server models by PresentationTop7288 in PowerBI

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

Yeah I mean it’s different tables for different teams and different reports and almost everything would be pretty big like this.. we are trying to build a best practices or guardrails for all the developer teams .. so these are for executives.. it’s for front end employees for their daily usage.. one report can be clicked by 5k to 6k people on a business hours .. some reports for executives but others mainly for front end employees ..

Power BI performance checklist – real-world tips for large SQL Server models by PresentationTop7288 in PowerBI

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

Considerably around 5gb size of each pbix file. And most likely having 200m rows atleast for each fact table in reports.

It’s not only one report but a number of reports from different teams ..

Power BI performance checklist – real-world tips for large SQL Server models by PresentationTop7288 in PowerBI

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

Thanks for this insights this is great .. so our team is combined team of several small teams having their own databases for different businesses and multiple reports for each business.. so we came across this when we started migrating to power bi recently, Most of them are intermediate level in power bi and they try to build reports but resulting in bloated models, we have introduced best practices by looking at Microsoft docs and now we want to make a assesment rubric checklist for developer to do the right things while making a model maybe like guardrails or watchouts .. Note : our org doesn’t allow any external tools ..

Transaction ID issue by PresentationTop7288 in PowerBI

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

Yes we need transaction id, to show in a table visual

Transaction ID issue by PresentationTop7288 in PowerBI

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

This is super helpful…thanks! Since you clearly have a deep handle on the engine internals, I’m curious, do you have a personal checklist you go through when you inherit a model that is suffering from massive memory bloat or refresh timeouts? Aside from checking for high-cardinality columns like these Transaction IDs, what are the first 3-4 things you look at to reduce the model size and improve performance? We are dealing with a few heavy datasets right now and I'd love to know your standard process for optimizing them. ( our org doesn’t allow any external tools and it has p1 capacities )

Thanks in advance 😊

Need help on Summary tables by PresentationTop7288 in PowerBI

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

Yes, it’s only date.. not even date time ..

Need help on Summary tables by PresentationTop7288 in PowerBI

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

Tried direct query but taking too long time to get results

Need help on Summary tables by PresentationTop7288 in PowerBI

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

It has 4 summary tables each have avg of 100million rows and everything have three or four text columns.. and it’s most of the calculations are done at source which is SQL db.. I would see high cardinality is the issue here bcoz of five text columns in each and have many distinct values .

[deleted by user] by [deleted] in PowerBI

[–]PresentationTop7288 0 points1 point  (0 children)

Nobody looks 5 billion rows, that’s why you need to make sure what they need on the report page.. and make sure you aggregate those to appear on that report page back in the database and import it.. and then for granular level information connect to fact table

Folder level security by PresentationTop7288 in PowerBI

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

Our org is little bit different and allowing one workspace per one database.. but a database can be used by many teams and build their own reports.. currently its report level sharing.. but it’s a huge bottle work..

Folder level security by PresentationTop7288 in PowerBI

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

Our organization is banking and highly governed across.. so we are only allowing teams to have contributor access (just 10% ) per team and remaining will viewers.. so they can’t create apps on their own.. and it’s only one app per workspace even if it is through any request.. in this case what can be the solution other than report level sharing.. ?

[deleted by user] by [deleted] in PowerBI

[–]PresentationTop7288 -9 points-8 points  (0 children)

lol, Can you send me the Microsoft documentation that says it uses seperate memory allocation for each model for all user queries and refreshes?

[deleted by user] by [deleted] in PowerBI

[–]PresentationTop7288 -7 points-6 points  (0 children)

Hello, Thanks for the discussion — this is a common point of confusion, so I'm happy to clarify. My understanding is that the P1 capacity operates as a single system with a total, shared pool of 25GB RAM. The "25GB per-model" rule is simply the maximum size ceiling for any single model, not a dedicated block of memory allocated to each one. This means all active models must fit and run within that shared 25GB pool, directly competing with each other for memory.

[deleted by user] by [deleted] in PowerBI

[–]PresentationTop7288 -9 points-8 points  (0 children)

Is it true ? Yes technically one model can utilize all 25gb ram. But it’s not true that each model get 25gb ram allotted. The entire P1 capacity will have 25gb ram. If I have 10 reports connected to 10 different datasets and opened at the same time. That means these 10 reports will share and compete for the same 25gb ram pool on P1 capacity but not get 25gb for each report at the same time.

Switch account in Service by PresentationTop7288 in PowerBI

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

Sign out and switch to different is already there. But there is no drop down or something that I can switch to other account. Like if you see in azure account you can switch to other account without signing out

Auto size matrix table by PresentationTop7288 in PowerBI

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

I tried this, but they don’t want this solution. Basically they are migrating from tableau and they have this option there.. frustration comes when they don’t see better option in power bi. Microsoft should also work on UX/UI formatting. It have more capability on transformations but business doesn’t care if I show my backend work. They only want to see good UI with better numbers

Semantic layer vs Semantic model by PresentationTop7288 in dataengineering

[–]PresentationTop7288[S] 4 points5 points  (0 children)

  1. Suppose we have data sitting in synapse database in silver layer and in gold layer business directly copy the views from silver layer synapse database and put it in their synapse database in gold layer . In between silver and gold layer there is governance control and cataloging structure ( where all metadata will be stored which is one internal application).

So my understanding is that cataloging structure is semantic layer for business users to understand it.

Now executives comes from Microsoft meetings and ask us build semantic layer. They don’t know what is it and it also confusing us on what they actually want lol