Forum Discussion

Pops1997's avatar
Pops1997
Regular Visitor
1 year ago
Solved

Refresh on Desktop but not on services without error

Hi,
I'm encountering an issue with Power BI and I can't figure out why it's happening.

I have the following setup in my report:

  • Closing dates (N and N-1) are manually inputted parameters.

  • Opening dates are dynamic. Specifically, Opening Date N = Closing Date N-1 + 1 day.

 

Based on these parameters, I have a parameters table that calculates the First Fiscal Month depending on Opening Date N.
For example, if Closing N-1 is in March and Opening N is in April, then the First Fiscal Month is 4.

 

 

Then, I have a Date Dimension table, which is supposed to be filtered based on that First Fiscal Month.

 

I've tried everything:

  • Using Date.Month directly from the Opening Date parameter.

  • Creating a new column with the Opening Date and extracting the month., Adding a column that returns true if FirstFiscalMonth = OpeningMonth.

  • Even creating a separate parameter manually inputted like "First Month".

  • I also tried filtering directly in the SQL query.

The issue is:
The refresh works perfectly in Power BI Desktop, including on the Date Dimension Table. But in Power BI Service, it doesn't refresh correctly only for the Date Dimension Table – all other tables update as expected.

 

For example:

  • In Desktop, I see "2" on both tables (as expected)

 

  • In the Service, it's still showing "4" on the Date table, which is outdat

 

No problem with refresh : 

 

Please help me

 

 

 

 

  • Hi, sorry if i wasn't clear, i did change parameters from services for services. 

    I found the problem, it was a silly mistake on my end. Leaving it here for history, have a nice day

     

     

2 Replies

  • If you change the parameter value on the desktop that will not automatically change the parameter on the service.  You would have to re-upload the PBIX to the workspace or you would have to go to the semantic model setting page and update the parameter there.

  • Pops1997's avatar
    Pops1997
    Regular Visitor

    Hi, sorry if i wasn't clear, i did change parameters from services for services. 

    I found the problem, it was a silly mistake on my end. Leaving it here for history, have a nice day