Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
No problem with refresh :
Please help me
Solved! Go to Solution.
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
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
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.
User | Count |
---|---|
11 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
16 | |
14 | |
8 | |
6 | |
6 |