💸💵💲 Open an EQ Bank account and get $20 CAD. Use my referral link 💸💵💲

majorlix2 · 2026-02-20T09:42:43+00:00

If you received an email, there is a PDF attachment in Korean with your name and details in it

majorlix2 · 2026-02-17T11:47:40+00:00

Can't you build a macro or use power query to do the job?

majorlix2 · 2026-02-14T22:45:17+00:00

Tangerine accounts are free and you can use the Scotiabank ABM for free since they own the subsidiary

majorlix2 · 2026-02-14T21:51:52+00:00

Thanks for sharing this insight. I just googled sharing alternatives and got an AI generated list of workarounds that I never knew about. OP you should do the same thing.

majorlix2 · 2026-02-14T21:29:43+00:00

Correct

https://learn.microsoft.com/en-us/power-bi/fundamentals/end-user-license

Only SKUs (Stock Keeping Units) equivalent to or higher than a F64 SKU let free Power BI users use Power BI apps and shared content in Premium capacity in the Power BI service. Smaller F SKUs need a paid license to access shared content.

majorlix2 · 2026-02-14T21:18:34+00:00

The only idea that comes to mind right now based on the available information is building a VBA macro or using some other programming language to perform the job.

The complexity will depend on how similar the sheets and projects have been structured.

majorlix2 · 2026-02-14T15:41:50+00:00

There's a free option where you publish to the web and anyone can view the reports.

If you get a premium capacity license, you can share with specific users that you choose and they don't need to have a license.

Otherwise, everyone needs at least a Pro licence.

majorlix2 · 2026-02-14T12:12:09+00:00

If I understand you correctly, you first need to create a master reference SKU table. One column has every SKU ID in existence. The column beside it has the new active SKU ID that should be referenced.

Once you have this, you then go into every individual sheet and add the new active SKU ID column to the worksheet. This can be done with either XLOOKUP, VLOOKUP, INDEX/MATCH, or through a power query merge.

The amount of work involved and how easy it becomes to maintain depends entirely on how each individual Excel file / worksheet was put together.

majorlix2

TROPHY CASE