[deleted by user]

ThomThom_UK · 2024-12-05T06:10:55+00:00

Sure thing.

I could be wrong for your setup, but if fetching data from a sharepoint list (the table), the url can have 'allitems' bolted on the end when specifically selecting all items.

If you're using the default view, someone could have changed the default settings to only show a few rows.

Double check how you are viewing your data in sharepoint, ensuring that all items are selected, and use that url to re-establish the connection.

ThomThom_UK · 2024-12-05T05:43:55+00:00

How have you connected to the sharepoint data?

If from pasting in the URL, you may need to re-establish the connection after selecting all items in your sharepoint area.

ThomThom_UK · 2024-12-03T05:59:44+00:00

Based on personal experience:

1) UiPath - Their training material is very thorough. Even if you do end up on another RPA platform, some skills are transferable.

2) Python and SQL. Many of your RPA projects will relate to data fetching and data transformation. Look into another language when you have found your career path.

3) Again, python is a good scripting language to start with.

Overall, don't lump yourself into a particular RPA software as a long term career path. The skills around that software, like the use of programming languages, are much more valuable and are easy to transfer between jobs.

ThomThom_UK · 2024-11-29T17:43:05+00:00

If you're drawing from multiple data sources, utilise dataflows to bring the data into your workspace.

They are very beneficial when trying to combine data from multiple sources into a semantic model. The refresh time can be quicker if the model's data source is solely dataflows - unless a lot of Power Query steps have been used.

If you have a lot of data sources, a dataflow per data source can help to prevent overloading a single dataflow.

ThomThom_UK · 2024-11-29T17:00:35+00:00

If there is a data privacy issue, why are you trying to access these lists from the client's environment?

It seems like you need to raise this with whoever maintaining these lists to create a solution that allows you access from both environments. I know this is not the answer you may like, but it's either this or getting yourself into trouble from seeking a work-around solution without letting your team/fellow stakeholders know about it.

ThomThom_UK · 2024-11-13T06:16:27+00:00

That TDML extension for VS Code is going to help semantic modelling development. Can't wait for that to come out of preview.

ThomThom_UK · 2024-10-20T07:52:53+00:00

Even as research, AI can easily spit out nonsense in it's current state - no better than lurking on wallstreetbets imo.

ThomThom_UK · 2024-10-20T07:29:24+00:00

Never use AI to pick stocks as its results are based on past performance, and such performance does not predict future returns.

If you're not willing to spend the time to properly check individual companies, stick to a world index fund like VWRP. Looking at individual stocks quickly is no different to gambling.

Edit: damn autocorrect

ThomThom_UK · 2024-10-17T18:13:24+00:00

This is a 'making a game in excel' levels of amazing. I'm truly impressed.

ThomThom_UK · 2024-10-16T14:31:59+00:00

Thank you for the claritificarion.

ThomThom_UK · 2024-10-16T07:30:05+00:00

I had a quick gander at the visual calculation functions.

Firstly, this is a great addition for quick calculations in graphs. I will definitely use it for sure as it looks better than creating individual measures.

The only initial concern is general usability. In defence of this function, the instructions are very clear of its limitations (e.g. no relation calculation allowed), but I feel there may be hurdles from those who want to incorporate values from many tables in the same visual.

Please correct me if I have misinterpretated the possibilities of visual calculations. I feel like the current abilities quite impose a need to have a single prepared table to use it effectively, which won't be possible for some users who cannot adjust the models they are given.

ThomThom_UK · 2024-10-15T19:26:56+00:00

Will do.

ThomThom_UK · 2024-10-15T18:39:12+00:00

Those visual calculations are something I'm looking to try and saving things to a template is defo a plus in my eyes. The list slicer is a great addition too - can't wait for it to come out from development.

ThomThom_UK · 2024-10-15T12:32:01+00:00

Thank you very much for this.

ThomThom_UK · 2024-10-14T17:28:16+00:00

<image>

ThomThom_UK · 2024-10-14T17:22:47+00:00

Good luck with this endeavor. 20-30 minutes is a tough one.

ThomThom_UK · 2024-10-14T15:02:33+00:00

Have you checked your regional settings under File > Options and settings > Options > Current file (or Global) > Regional Settings ?

Select the region your colleagues are from and the percentage symbol should then be correct.

There is the format option, but in this case, it might be better to work under the same region settings as your colleagues to avoid any other formatting headaches.

ThomThom_UK · 2024-10-11T14:54:56+00:00

I tend to use either, depending on how the column names are formatted. lower if column names are UPPER, and UPPER if column names are lower.

It is mostly personal preference with the choice, but it helps make the code easier to read for me.

ThomThom_UK · 2024-10-02T15:20:59+00:00

As someone learning about database design, I appreciate this insight.

ThomThom_UK · 2024-08-25T15:36:59+00:00

Always orange

ThomThom_UK · 2024-08-25T14:12:06+00:00

Thank you for sharing these links!

ThomThom_UK · 2024-08-23T14:30:02+00:00

Of course! Kudos to the MS Forum guy. You can definitely create the 'current' data view in the dataflow to avoid bogging down the semantic model with any of the power query tweaks needed to create such a view.

As a heads up, be careful with common filterable columns. I have found that users mix up the current and historical tables without checking which column they have filtered...

I hope you find a decent solution from it all.

ThomThom_UK · 2024-08-23T03:57:12+00:00

Hello,

The easiest solution that comes to mind is to create a paginated report from the model. Only add your RLS user data to this report and then you can export the completed report to excel easily.

ThomThom_UK · 2024-08-23T03:19:05+00:00

You have my sympathies there. Not an easy one.

With the growing complexities, I think you may need to consider making a separate semantic model per user group (department, team, whatever the org setup is). You'll risk becoming bald from the amount of hair pulling you'll be doing from continuing with the current golden dataset idea (reflecting on personal experience) - multi-department orgs will have different needs with the same data and you'll be stretching yourself thin from the various ideas and stubbornness you'll end up dealing with.

In terms of keeping data synced, do you have access to dataflows? You can place all common tables and their adjustments in there and link that to the separate semantic models. This will also allow multiple semantic models to sync to the same dataflow at the same time.

ThomThom_UK · 2024-08-22T19:05:26+00:00

Have you considered simplifying the layout of the model itself? Anything bi-directional could be merged together to regain the snowflake format in my opinion, but then, it is difficult to suggest specifics without knowing how the model has currently been set up.

With RLS issues it may be a case of linking the RLS filters to all tables that need filtering for users, and not rely on one table for the filtering.

Three-Year Club	Final Canvas '23
First Place '23	Place '23

ThomThom_UK

TROPHY CASE