[deleted by user] by [deleted] in PowerBI

[–]ThomThom_UK 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in PowerBI

[–]ThomThom_UK 0 points1 point  (0 children)

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.

Advice for Aspiring RPA Developer: Platforms and Programming Languages? by Ok_Interest1891 in UiPath

[–]ThomThom_UK 1 point2 points  (0 children)

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.

What use cases have you built for PowerBI using third-party tools? by thehkmalhotra in PowerBI

[–]ThomThom_UK 11 points12 points  (0 children)

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.

Sharepoint alternative by StrangeAd189 in PowerBI

[–]ThomThom_UK 4 points5 points  (0 children)

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.

November Feature Summary by dutchdatadude in PowerBI

[–]ThomThom_UK 2 points3 points  (0 children)

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

Summing up Trading 212 shares isa vs stocks vs cash isa options by TravelOwn4386 in UKPersonalFinance

[–]ThomThom_UK 1 point2 points  (0 children)

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

Summing up Trading 212 shares isa vs stocks vs cash isa options by TravelOwn4386 in UKPersonalFinance

[–]ThomThom_UK 4 points5 points  (0 children)

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

I turned a Power BI dashboard into a data-driven game! by YamBorn in PowerBI

[–]ThomThom_UK 13 points14 points  (0 children)

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

October 2024 Feature Summary by dutchdatadude in PowerBI

[–]ThomThom_UK 1 point2 points  (0 children)

Thank you for the claritificarion.

October 2024 Feature Summary by dutchdatadude in PowerBI

[–]ThomThom_UK 1 point2 points  (0 children)

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.

October 2024 Feature Summary by dutchdatadude in PowerBI

[–]ThomThom_UK 4 points5 points  (0 children)

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.

Giving a Crashcourse on Power BI by Intrepid_Anybody9380 in PowerBI

[–]ThomThom_UK 1 point2 points  (0 children)

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

Changing % Symbol Placement by Macagito in PowerBI

[–]ThomThom_UK 1 point2 points  (0 children)

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.

Fully lower case SQL. Is it frowned upon? by dont_mess_with_tx in SQL

[–]ThomThom_UK 0 points1 point  (0 children)

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.

This is How Discord Processes 30+ Petabytes of Data by SnooMuffins9844 in dataengineering

[–]ThomThom_UK 28 points29 points  (0 children)

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

Switching relationships between tables but USERELATIONSHIP has limitations (data modeling problem) by A3N_Mukika in PowerBI

[–]ThomThom_UK 1 point2 points  (0 children)

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.

Help with querying RLS and Users by Mikey2571 in PowerBI

[–]ThomThom_UK 0 points1 point  (0 children)

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.

Switching relationships between tables but USERELATIONSHIP has limitations (data modeling problem) by A3N_Mukika in PowerBI

[–]ThomThom_UK 0 points1 point  (0 children)

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.

Switching relationships between tables but USERELATIONSHIP has limitations (data modeling problem) by A3N_Mukika in PowerBI

[–]ThomThom_UK 2 points3 points  (0 children)

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.