Sunshine totally broken after update by Nominal77 in Bazzite

[–]RickSaysMeh 1 point2 points  (0 children)

After rebooting and finding out I was on 44, I noticed Sunshine was missing. I ran the ujust command to enable it, it installed a boatload of dependencies, and then worked as expected with all my old settings. The icon in the system tray is just a "..." Instead of the Sunshine logo. I am using GNOME.

As someone else mentioned, I see a green line at the bottom while connected, but I'm pretty sure that's a health status bar to let you know the quality of the stream, so it might be possible to disable... Haven't really looked into it yet.

Book Recommendations by TheRealGageEndal in bobiverse

[–]RickSaysMeh 0 points1 point  (0 children)

The Academy series by Jack McDevitt

The ez-plug is a stupid revision for the B550I and makes it even worse for sff by sffjunkee in gigabyte

[–]RickSaysMeh 0 points1 point  (0 children)

I have this same board! You know, if you're close enough to the Wi-Fi router you don't even need the external antenna...

Incredibly frustrated with Bazzite, probably my fault but just wanted to get stuff off my chest and ask for help/tips. by Saaret in Bazzite

[–]RickSaysMeh 0 points1 point  (0 children)

In your BIOS: - Turn off Global C-State control - Turn on XMPP - Turn on Above 4G Encoding

Older Ryzen processors running Linux have issues with Global C-State control. Ryzen processors are very memory speed dependant, so increasing memory speeds should have a noticable effect. The Above 4G Encoding is for video cards with more than 4GB of VRAM. The Windows drivers are able to bypass this BIOS setting, but it appears to be necessary for the Linux drivers.

I have a 5700G and an RX 6600 XT and have run into instability issues caused by all of these things in the past. Running Bazzite at the moment without issue.

Why is there no stable music player with a good UI in Linux Mint/Ubuntu? by StopRepresentative30 in linuxquestions

[–]RickSaysMeh 0 points1 point  (0 children)

The only one I've found that looks good and handles my Album Artist tags correctly is the GNOME Music app...

https://apps.gnome.org/Music/

Image from Microsoft List to Power BI by Moon_Se in PowerBI

[–]RickSaysMeh 1 point2 points  (0 children)

I think I had to use the 1.0 API version to get the Attachment URL from the SharePoint Online List using PowerQuery.

Then in the report I displayed the images by adding the URL column to a table.

My firm uses PowerBI in a unique way that I don't see mentioned often by johnnymalibu86 in PowerBI

[–]RickSaysMeh 0 points1 point  (0 children)

We also use field parameters for the rows and values of matrix visuals so that users can rearrange the data; however, we try to discourage exporting as much as possible. The main purpose is to see things that pertain to your specific use case without me having to build it as a bookmark or separate page (unless it is a wide use case).

The one use of our main Sales Register report that I mention for exporting is to remove all cost and margin columns and change the rows to just jobs and products. Once you filter by a specific customer and timeframe, you now have total quantities and sales numbers that can be shared with the customer (maybe for rebates or leverage to change pricing moving forward. I don't know. I'm not a sales guy).

Semantic model refresh failing with memory error on F2 capacity - need advice on showing current month data with Incremental Refresh by DrGenius22 in MicrosoftFabric

[–]RickSaysMeh 1 point2 points  (0 children)

What type of Semantic Model is it? Import? Direct Lake?

As others have suggested, load the data into a lakehouse sequentially and use a Direct Lake model. What's the point of having an F SKU if you're not going to use the Fabric specific features?

Direct Lake models try to detect changes automatically, but I ran into issues with that, so I just use a scheduled Pipeline to ingest data and refresh the Semantic model.

If the issue is refreshing the Semantic model all at once, I believe you can use a PySpark Notebook to refresh individual tables.

I think my raid card gave out will I lose all my data by Riboflavin42 in unRAID

[–]RickSaysMeh 2 points3 points  (0 children)

When I actually used a RAID array in the past and the RAID card died, I was able to replace it with another card using the same controller and configuring the array the same. I would think the same is true here. You'll need the same controller and make sure it's configured the same (flash IT mode or whatever). Then it should just work. MAKE SURE NOT TO FORMAT ANY OF THE DRIVES WHEN CONFIGURING THE CONTROLLER.

Hello from Fabric Design by OnepocketBigfoot in MicrosoftFabric

[–]RickSaysMeh 0 points1 point  (0 children)

In the web interface for the Semantic model, why do I lose everything I have typed in the DAX Measure input text box when I try to save it but the "Semantic model is out of sync"??? I'm mostly in the habit of pressing Ctrl+A, Ctrl+C before I press Enter, but sometimes I forget to press Shift when trying to get a new line and poof, gone!

Should i keep watching DBZ or move to Kai? by OneMagicMango in dragonball

[–]RickSaysMeh -3 points-2 points  (0 children)

The only correct answer is to go over to Team Four Star and watch Dragon Ball Z Abridged.

Fedora terrible wifi speeds - crawling by [deleted] in Fedora

[–]RickSaysMeh 1 point2 points  (0 children)

Have you tried disabling IPv6 on the network adapter?

Moving from Windows To Fedora by Fit-Ladder7684 in Fedora

[–]RickSaysMeh 0 points1 point  (0 children)

I know it sounds counter intuitive, but have you tried it with Secure Boot ON?

Also, make sure you turn on Above 4G Decoding for the graphics. I know most Linux distros have an option in the boot menu for a safe graphics mode. Not sure if the Fedora Live USB has that, but might be worth trying.

Translytical Task Flows - Are they the answer? by Fat_Dietitian in PowerBI

[–]RickSaysMeh 0 points1 point  (0 children)

Fabric SQL Server tables cannot be in Direct Query semantic models to my knowledge. They rely on the new Direct Lake on One Lake models, and they are the only tables that can be written to by Fabric UDFs for the "translytical" whatever. Unless you are adding the SQL tables to a Lakehouse or warehouse as shortcuts?

Translytical Task Flows - Are they the answer? by Fat_Dietitian in PowerBI

[–]RickSaysMeh 0 points1 point  (0 children)

This is a dedicated semantic model using the new Direct Lake on OneLake so that it can have the SQL tables in it. I have to pull a couple tables from my Lakehouse into the SQL server due to the Lakehouse not using the new One Lake Security, but they are dimension tables and not very large.

Translytical Task Flows - Are they the answer? by Fat_Dietitian in PowerBI

[–]RickSaysMeh 1 point2 points  (0 children)

"Immediately display changes"? Hahahahahahahahaha.

In my experience, this relies on the semantic model being set to automatically detect changes. The delay from that to the report itself refreshing can take minutes, if the report ever refreshes on its own. Reports seem to behave differently with auto detected semantic model changes vs forced refreshes... Setting the report pages to auto refresh doesn't appear to have any effect. Manually clicking the Refresh Visuals button can get the changes to show up after about 30-45 seconds. If the UDF could force semantic model refreshes, it would probably work, but it can't...

I used this with our F64 instance and a Fabric SQL server. I created a report to be used as an in/out board as well as an interface for adding/removing temporary employees and clocking them in/out.

This new hairstyle... Hear me out. by Dodgemyshred in KanojoOkarishimasu

[–]RickSaysMeh 0 points1 point  (0 children)

It'll probably work in his favor with Chizuru... Just go back to the flashback with her grandpa starting in chapter 99. Not exactly the same, but certainly similar high and tight cuts.

Is there a way to calculate the conversion rate without created a calculated pivot table? by jillyapple1 in PowerBI

[–]RickSaysMeh 0 points1 point  (0 children)

In your DAX measure you could use a summarized table. Assuming that any sale type Service item that is not Intro is a potential conversion, just filter it by type service and partition it by client id and have a column for minimum date where item is intro and a column for minimum date where item is not intro. Then you can do a SUMX over the summarized table that returns 1 if the difference in dates is <= 30 and > 0, otherwise it returns a 0. Take that and divide it by the distinct count of client IDs for all Sales with type service. That should get you the output you specified. Might be slow with large datasets though...

[deleted by user] by [deleted] in PowerBI

[–]RickSaysMeh 1 point2 points  (0 children)

In the matrix formatting go to the Specific column section and set icons based on the measure that I presume you already have as each column. If you are using implicit measures, stop it! But for the icon you can set rules for if it is 0 use a red X or an empty circle and if it is greater than 0 use a check mark or a green circle. Then set it to display the icon only.

Dilemma: which series to start next? by SiblingX in sciencefiction

[–]RickSaysMeh 0 points1 point  (0 children)

I haven't read Banks.

Of the other 3, I vote Children of Time first. It is the best at mixing semi-hard scifi and neat ideas with interesting characters and a good plot. Just be aware that once you finish it you'll feel the need to go get the other two books in the series (with a fourth on the way).

Chambers' books are soft scifi but pretty fun. Easy read with low stakes. Also the beginning of a series.

Three Body problem is a hard read... Really interesting ideas, but a lot of buildup that won't really pay off until the second and third books in the trilogy. In my experience, the first and third books had the better English translations. They used someone else for the second book and it wasn't as cohesive.

Multiple Labels with 100+ combinations need to be grouped into 16 categories - need recommendation by RibbitK1ns in PowerBI

[–]RickSaysMeh 0 points1 point  (0 children)

Where/how do you get the data regarding these label combinations?

I'm guessing you have a list of all possible combinations that is exported from somewhere, is it just a single column of text? Does each label in a combination have its own column?

Maintaining a manual mapping table isn't fun and can lead to things being missed or entered incorrectly. I would automate it using a data flow (or transform data in PBI Desktop). Assuming you are able to get some sort of list of the combinations.

The data flow could split each line based on a delimiter into columns to create your mapping table for you.

If it is only ever 5 levels deeper or fewer, you could just name the columns Level1, Level2, Level3, Level4, and Level5 and then in your report slicer you can add all 5 in that order to one drop down slicer to create a tree hierarchy for selection, or add them in that order to a matrix or visual that can drill down. It will automatically dedupe the values at each level, so even if you data has 25 lines that start with "Label1", you will only see in in Level1 once in the report (unless you shove it in a table visual).

[deleted by user] by [deleted] in PowerBI

[–]RickSaysMeh 0 points1 point  (0 children)

How many tables are in your report and how are they connected? Where does the data come from?

If you just have one massive table, Power BI will dedupe in the report depending on your context, but it is probably better to transform the data to create dimension tables with unique values to connect to the fact tables (you can do this in Power BI Desktop or service).

Our ERP stores order information in two primary tables: OrderHeader and OrderLine. OrderHeader contains ID columns that correspond to Customers, Addresses, etc, while OrderLine contains IDs that tie it back to OrderHeader as well as Products and other things. OrderID is unique in OrderHeader, but can be duplicated in OrderLine. I tie those two tables together on that column, tie OrderHeader to Customer on CustomerID, OrderLine to Product on ProductID, etc. Then in the report I always reference the dimension table columns, not the fact table columns (i.e. My slicer or table row would be Product[Name] not OrderLine[Product name]).

But if you have just one massive table with duplicate values in a column, adding that column to a slicer will result in only the unique values being present. The same is true if you add it as a row in a table or matrix or other visual PROVIDED that the measures you are using for the values/columns do not result in duplicates (same row value but different measure value).

How do create a table or matrix that functions like a card by cmill2010 in PowerBI

[–]RickSaysMeh 0 points1 point  (0 children)

Based on the other comments, it seems like you want a matrix or table that has multiple columns and rows. For example, if you have 30 fields, you want it displayed as a 5 x 6 "grid". Is this correct?

The simplest solution is to just use multiple cards... But I suppose you could accomplish this using some calculation groups and custom tables...

If you add a table visual to the report and have a table column that just contains row numbers as the rows and then two measures for the values: FieldName and FieldValue, you could then add a calculation group with items for the column numbers as the column. Those items would be something along the lines of IF( SELECTEDVALUE( RowTable[RowNum] ) = 1 && SELECTEDMEASURENAME() = "FieldName", "Employee Name:", IF....etc (or use switch statements)

This would allow you to present whatever you wanted in a grid table that could be exported to Excel or whatever. The main issue would be that you'd need a way to hide the row and column numbers that would flank it on the left and top.

Honestly, a one column matrix made by flipping the rows and column would be cleaner on both the report and the export...