Empty date columns after web refresh

[Nico_Beckers]

Hello, 

I'm having an issue with 2 tables that are being filtered through a DIM Date table.

In desktop app and after first upload I get this:

So my DIM date filters the other tables.

After the refresh on the service, this is whats left:

When I try to explore the data on the web service, these columns appear to be empty.

Does anyone have a clue what's happening here?

Kind regards,

Nico

[Idrissshatila · Accepted solution]

Hello @Nico_Beckers ,

what I suggest to do so you could know why, is to download the service pbix and check it there.

[Nico_Beckers]

@Idrissshatila: Thanks, this made me look my subsequent power query steps. Turns out that filtering my dataset in powerquery on the desktop vs it filtering on the web service happens in a different way. Changed the filtering into 'text contains' instead of unchecking the boxes in the dropdown filter pane, and now it works perfectly.

[Idrissshatila]

@Nico_Beckers ,

Great, happy to help!

[Nico_Beckers]

Hello, 

It appears that both table have no data loaded from the SQL server they connect to. When I refresh the downloaded file on my desktop, everything refreshes properly...

KR,

Nico

[v-jianpeng-msft]

Thank you @Idrissshatila , your ideas is so great !

Hi, @Nico_Beckers 

You mentioned downloading the PBIX file from Power BI Service, opening it in Power BI Desktop, refreshing it for you to be able to see the data. This means that in Power BI Service, you need to configure the gateway connection and refresh your semantic model.

You can follow the following tutorial to configure the gateway connection to SQL Server:

Manage a SQL Server data source - Power BI | Microsoft Learn

To refresh the semantic model:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.