Expansion in query works on desktop, but not online

[Anonymous]

Query, "M" code which shows how list of date ranges gets expandeddesktop version, data appearsonline version, data does not appear

Hello world,

so I have a query which expands a date range.

The expanded data is then filtered and counted.

This works in the offline version flawlessly. As soon as the dataset is uploaded to PowerBI-Online, it doesn't work anymore.

Anyone have an idea or a reason, maybe even an idea for a workaround?

Screens attached.

All the best,

c4ss10p314

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

As tested with the circled query for my scenario, It finally creates a column with lists of dates.

close&&apply, then load it into data model, 

after publish it to Power BI Service, it works as expected.

I don't know what cause the strange thing on your side.

You could update power bi to last version, use the lastest web browser( i use chrome).

You could also use my pbix to make a test on your environment.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie,

thank you very much for all the work you put in.

I reuploaded it, and it suddenly worked. Weird, but however: thank you so much!!