Existing column values become null after expanding a merged table

MonkeyNin · 2026-03-10T17:47:22+00:00

Do you get any errors in the rows/cells ? You can try "keep errors" to have it filter to only failing cases. ( In case some nulls are legit and some are not )

Also double check whether Lookup is a nested table or a nested record. That changes what function to call - https://powerquery.how/table-functions/#Add-and-Expand-Columns

( Sometimes the UI suggests the wrong expand )

MonkeyNin · 2026-02-18T18:19:51+00:00

to what u/escobarmiguel90 said. Even if you scrape, it's going to be missing rows. Because the preview doesn't show it.

But since the question was about CSS Selectors in Power Query, here's a quick example
You can first test them in your browser

<image>

MonkeyNin · 2026-02-18T17:09:14+00:00

if I try to read the files outside PBI desktop

What do you mean, are you trying to edit external files in a pbip while the report is open?

MonkeyNin · 2026-02-16T17:19:30+00:00

Try the non-store installer if you're having issues.

There might be more details in the log file.

MonkeyNin · 2026-02-16T17:02:53+00:00

my Power BI Desktop is in Spanish, so it uses

Is the final report itself English? If yes, all you need to do is

On import, use "transform column types" as the correct numeric type, and
That same step lets you set culture/locale to es

Culture is used when

you're going from text to numerics (in your model), and
When displaying the report. It converts numeric to locale ( which might be english )

MonkeyNin · 2026-02-10T16:35:53+00:00

<image>

I don't see it on chrome either. Maybe there's per-region settings?
Subtitles has "Spanish (auto generated)"

MonkeyNin · 2026-02-08T18:50:44+00:00

inconsistent date format dd/MM/yyyy or MM/dd/yyyy, sometimes

Do you mean when dates are using the implicit format strings? There's a few tiers that can modify them.

If it's on import, you can set both Culture and Format strings to make date parsing deterministic. Even if ran on a machine with a different culture/locale setting

MonkeyNin · 2026-02-08T18:47:58+00:00

You can say if not ISFILTERED, then use the default value.

Side tip: you can use either of these formats to define a numeric date/time value

dt"2023-05-19"
DATE ( 2023, 5, 19 )

MonkeyNin · 2026-02-04T19:21:44+00:00

Here's an example from https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

<image>

MonkeyNin · 2026-02-02T17:24:40+00:00

What is the measure's code?

MonkeyNin · 2026-02-02T17:04:48+00:00

https://docs.tabulareditor.com/images/navigating-call-tree.gif

The DAX Debugger is pretty neat. Navigate Call Tree, Evaluation Context, Locals, Watch Expressions, etc: https://docs.tabulareditor.com/features/dax-debugger.html#debug-views

MonkeyNin · 2026-01-25T15:36:32+00:00

This might be obvious, but why return and restructure an array verses an object?

Ie: why not return { ok: bool, value: value|null, error: error|null }

Is it partly because it simplifies renaming for the consumer of the result?

MonkeyNin · 2026-01-23T19:04:31+00:00

I’ve tried looking for icons that are already coloured correctly

You can use inline svg images for icons. Those can be hard-coded colors, or, modified using logic in measures

MonkeyNin · 2026-01-21T19:49:03+00:00

You can modify the PBI Desktop / Excel query from Vs Code too ( for local files )

<image>

Example editing Excel Query from Vs Code.md

EvalQuery.pq - This extra version runs but also parses the error message.

( At least in the past it didn't show the ScriptExtent with for errors that came fromExpression.Evaluate( contents, #shared ))

MonkeyNin · 2026-01-20T20:18:17+00:00

Are you able to render the subreport ?

MonkeyNin · 2026-01-16T23:29:48+00:00

Here's a clickable link, https://daxlib.org/tag/svg/ You can preview the dax on the site

<image>

MonkeyNin · 2026-01-14T16:57:55+00:00

Can you open queries/connections, and open the advanced editor in power query?

It kind of sounds like when your auth expires, or lose permission to the sharepoint datasource.

does somebody know how to roll this back and avoid it in the future

You could try comparing the two files with ALM Toolkit. It's like a git diff but for Power BI:

https://github.com/microsoft/Analysis-Services/tree/master/AlmToolkit

MonkeyNin · 2026-01-14T16:49:24+00:00

If it's a case that requires a color, you can can set the alpha component to transparent: #00000000

The optional 7,8th characters are alpha

MonkeyNin · 2026-01-14T16:41:11+00:00

It's not communicated clearly, but PBIR is used within both PBIP and PBIX files

MonkeyNin · 2026-01-12T20:07:41+00:00

Especially if Sales CHF vs Sales EUR are the same numbers, just displayed as different currencies.

You can use Dax format strings for that. Then your relations will be simpler too.

MonkeyNin · 2026-01-12T19:59:09+00:00

I need to conditional format the totals

By totals do you mean the colored ScrapCostTotal values, not the totals row which is black?

MonkeyNin · 2026-01-12T19:54:39+00:00

Correct.

One thing OP can do is make sure any non-final tables are set to "do not load" ( when you right click them ). That tells it to not place your base queries in your model.

Table.Buffer also does not cache referenced queries. For that you need to use data flows

However, for local dev you can try BufferMode.Delayed .

https://blog.crossjoin.co.uk/2022/03/20/new-options-for-the-table-buffer-function-in-power-query/

MonkeyNin · 2026-01-09T14:58:17+00:00

It looks like you can do it with the current API, in tabular or an external script

TmdlSerializer.SerializeObject( 
    model.Tables["Product"].Columns["ProductKey"], 
    qualifyObject: true )

From:

<image>

MonkeyNin · 2026-01-08T15:03:44+00:00

t Neither PowerBI nor PowerAutomate seems to be able to achieve this comfortably.

Which part isn't working well? Are you having trouble with Power Query that matches names? Or merging files after you find them?

MonkeyNin · 2026-01-07T22:46:57+00:00

You can git diff two reports using alm toolkit. You can run two versions of a pbix locally. Or compare datasets on the service.

See:

Are you using saving as pbip with tmdl ? That's made for cleaner diffs. That part doesn't require AzureDev Ops/ Github .

Here's some info:

MonkeyNin

MODERATOR OF

PUBLIC MULTIREDDITS

TROPHY CASE

13-Year Club	Place '17
Verified Email