Forum Discussion

Nico_Beckers's avatar
Nico_Beckers
Frequent Visitor
2 years ago
Solved

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. Aft...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello Nico_Beckers ,

     

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

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

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's avatar
Nico_Beckers
Frequent Visitor
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.