Reply
Nico_Beckers
Frequent Visitor

Empty date columns after web refresh

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:

Nico_Beckers_0-1722338962072.png

So my DIM date filters the other tables.

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

Nico_Beckers_1-1722339031583.png

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

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @Nico_Beckers ,

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Idrissshatila
Super User
Super User

Hello @Nico_Beckers ,

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




@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.

@Nico_Beckers ,

 

Great, happy to help!



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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

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

vjianpengmsft_0-1722834443084.png

To refresh the semantic model:

vjianpengmsft_1-1722834570080.png

 

 

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.

 

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)