- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Nico_Beckers ,
what I suggest to do so you could know why, is to download the service pbix and check it there.
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Nico_Beckers ,
what I suggest to do so you could know why, is to download the service pbix and check it there.
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great, happy to help!
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
08-07-2023 05:58 PM | |||
05-10-2024 03:36 AM | |||
Anonymous
| 04-02-2024 06:27 AM | ||
08-08-2024 10:34 PM | |||
07-24-2024 04:56 AM |
User | Count |
---|---|
50 | |
31 | |
30 | |
26 | |
24 |
User | Count |
---|---|
47 | |
33 | |
18 | |
18 | |
15 |