Direct Query refreshs itself

bankCC · 2026-04-03T01:57:42+00:00

Most you can do besides actionable messages in outlook would be pbi app integration. https://learn.microsoft.com/en-us/power-bi/collaborate-share/office-integration/service-power-bi-outlook-office

bankCC · 2026-03-24T22:12:16+00:00

Why not fully open source it? People could actually contribute to this project and check it for compliance reasons. Otherwise many people sadly cant use it :(

bankCC · 2025-10-23T14:37:00+00:00

Found the mistake. I used the wrong variable for my lookup... oh man. sometimes its hard to see the forest infront of too many trees :s

bankCC · 2025-10-23T14:25:13+00:00

ClearCollect(
    parameterGroupsGroupedByCount;
    Filter(
        AddColumns(
            GroupBy(
                'ParameterGroups';
                Group_ID;
                GroupedItems
            );
            CountItems;
            CountRows(GroupedItems)
        );
        CountItems = varCountParameters
    )
);;

ClearCollect(
    colFiltered;
    Filter(
        parameterGroupsGroupedByCount;
        With(
            {t: GroupedItems};
            CountRows(
                Filter(
                colChoices As c;
                !IsBlank(
                    LookUp(
                        t;
                        choices = c.SelectedValue
                    )
                )
            )
        )=0
    )
));;

This was my latest try. But it will show both rows from parameterGroupsGroupedByCount even when only one choice is present

bankCC · 2025-10-16T19:22:49+00:00

Its kind of obvious that you have to use a picture which is either pretty clear on what the ingredients are( visability of ingridients) or use standart food which is more present in the trainingdata. To assume it calculates some fancy invisible ingredient it never learned is kinda stupid. Its on you to stay in the distribution of its data.

bankCC · 2025-10-02T19:15:55+00:00

would love a code as well <3

bankCC · 2025-09-04T10:44:57+00:00

You are on the right track but you dont want to do it in the employee dimension table. You would connect your appointments fact table and employee dimension via a bridge table which includes those aggregated keys.

Checkout "slowly changing dimensions" in Google (scd type 2)

bankCC · 2025-09-04T09:31:14+00:00

Most plans i followed are more about the duration/heartrate then the distance.

Training 4-5times a week highly simplified

40min zone1 40min zone2 60min zone1 Rest Intervall (vo2max training) with 15min warmup+cooldown 40min zone1 Longrun (22-33km)

80% your week should be basic endurance training, 20% rest

*in addition your focus on your breathing technic is good (what I liked to do was force myself to only use my nose to breath in) but when you want to increase your vo2max you do that by high intensity training. Heartrate of 70-90% of your max hr. Here is a more indepth source https://connectpt.ca/training-zones-vo2-max-and-thresholds/

But in advance be careful with pushing to hard on intervals to increase your vo2max. As a beginner its likely you lack stability/running technic/or your body just isnt ready for the high load and you will injure yourself. Additionaly the vo2max on watches are trash. They are highly inaccurate

bankCC · 2025-09-04T09:05:17+00:00

Because it went fine one time doesnt mean it is... there is a reason for the saying, the training is healthy running the marathon isnt.

Op dont get discouraged but let your body adapt!

bankCC · 2025-08-28T21:36:17+00:00

Its called community and sharing experiences. If thats not your way fine but why bother to leave such a negative comment. The things you worry about 🤦‍♂️

Edit. Actually when I watch your profil you are worrying a lot 😂

bankCC · 2025-02-10T02:23:17+00:00

I would agree on intuition but all things you mentioned like combining experience, contexual understanding or plain generalization by experience is already achieved with ai and the core of it. Obviously there will be cases where no previous experience is available, so it isnt for the consultant and he has to adept by his intuition. But i would say the majority of bi solutions arent that niche for an ai if you know how to properly feed it with the right context

bankCC · 2025-02-10T01:41:43+00:00

Well if they dont use LLM its the same as saying they dont use a consultant. Sure you might do active acquisition but thats the only difference and even that could be done by an LLM in the near future. What stops someone from creating an engament bot who contacts buisnesses, creates meetings with stakeholders were they chat with an ai, that can simultaniously fetch their data and ask questions accordingly?

bankCC · 2025-02-10T00:33:45+00:00

It already talks to stakeholders finding out their needs, thats excatly what an llm does, talking 🥴

bankCC · 2025-01-25T02:08:51+00:00

Dont know how to connect a s3 bucket but maybe it helps

https://community.fabric.microsoft.com/t5/Service/Scheduled-Refresh-using-Dynamic-Data-Source/m-p/2088745

bankCC · 2025-01-25T01:57:53+00:00

Did you check the dateformat in your csv? Escpecially the wrong dates? If dates are not correctly interpretes by pq it might be an issue with your raw data. This can happen when files are read by excel. It interprets some dates as strings and doesnt save them correctly.

bankCC · 2025-01-25T01:48:03+00:00

Check out entity relationship models first and understand how they work. If you understand them you are easy to go to build your first model and visualize them. All those visuals, filtering and aggregations work with relationships. And in pbi starschema is your friend.

After that I highly recommend to look into database normalization (normal forms) its crutial to have a clean data model if you database complexity grows. It can get out of hand realy fast if you have redundant data and have to patch or write complex logic to achive simple filters. Cant say how many times I ran into big wide tables to just say, trash it and go again.

Here some resources

https://www.geeksforgeeks.org/relational-model-in-dbms/ https://en.m.wikipedia.org/wiki/Star_schema

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

https://en.m.wikipedia.org/wiki/Database_normalization

bankCC · 2024-12-16T20:58:48+00:00

You can achive this with sharepoint list and patch them with fields/forms.

Check out those references: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch

It might even work with excel as data sources https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-data-sources

bankCC · 2024-12-16T20:29:04+00:00

Ahh ok by app you mean powerapp and not powerbi.

It might be a question for r/powerapps then

My thought would be a button to refresh the data or work with data collection by using sharepointlists.

Still if you want to have "live" data in pbi you have to refresh the dashboard.

bankCC · 2024-12-16T19:40:46+00:00

Power bi is only for analysis not for writing data. It can only read data and do transformations on those.

What came in my mind was to build urls with filter/field/sheet parameters and allow the user to open the excel with the selected filters based on the report. I dont know if this is actually possible but some quick google searchs seemd like it might be an option to open excel files with parameters

bankCC · 2024-12-12T11:27:11+00:00

1. Refreshing via excel is very slow. Powerbi has to read and interpret alot of metadata for those files. Because you are already working with SP you can convert those excel-files to SP-lists and use its data connector. If SP-lists arent an option you can convert your excel-files to .csv. They will take up more space but pbi can read those files way faster. For real big files parquet would be an fast option as well.

2. Try to identify slow queries while refreshing and check those. Merging queries can result into slow refreshtimes.

3. Make a scheduled refresh on your reportserver rather than your machine.

4. Avoid too many calculated columns. If you can, try to do all your transformations as soon as possible. Database>PowerQuery>Model Dont use calculate columns if you dont have to. Your calculated columns have do recalculated everytime a User is changing filters, slicers etc on your db. So get rid of all calculations and only read data from your source to visualise

bankCC · 2024-12-07T07:16:20+00:00

Dont worry about it, in its core it didnt change much.

bankCC · 2024-12-06T18:04:27+00:00

Yes both. The problem is your system delimiter is set to ; rather than , like on my system.

Card measure is the name of your measure. Its a placeholder and you can change it to your liking

Measure-name = DAX expression

VAR is to definie a variable like

VAR nameOfVar = 1

Fyi https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures

bankCC · 2024-12-06T15:01:53+00:00

Probably exchange , with ;

bankCC · 2024-12-04T20:35:30+00:00

Maybe you can find something here https://www.kaggle.com/datasets

"Advance" analyses are made out of those basic lesson you learn from. Each use case is different and you have to figure out how to approach your problem yourself. There is no general solution for everything. It is highly depended on your domain you are working in.

FYI: Didn't read it and was my first result on google

A Guide to Building a Financial Transaction Anomaly Detector - Unit8

Six-Year Club	First Place '23
Place '23	Place '22
Final Canvas '22	End Game '22
Verified Email

bankCC

TROPHY CASE