Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello community!
I hope that someone can help me to resolve this issue that I'm facing. It seems very easy, but I'm not eable to resolve it.
Well, the problem is the update of the new year in the power bi reports. The data is located on the sharepoint and can see the reports on the workscpace (Screenshot1)
I duplicated the original report S to the C one. And I'm tryinf to download it, because I ca'nt edit the DAX or the functions in the "server" reports. There is no option to export in .pbix format and if I make a save as I cannot open it locally as it is saved in the workspace (screenshot 2).
The second problem is that I have used a copy that I have locally to edit the function but I can't replicate the same function in the original report I created a new measurement but I can't configure it as a sum like this:
In brief, what I want to do is very easy. I want to correct the function that is incorrectly filtering the year field. But I have not been able to download the report to edit it locally and republish it.
If anyone can help me with this or if there is another way to solve it, I will be very grateful to receive your help.
Thank you in advance!
Solved! Go to Solution.
UPDATE post !!!!!
I have managed to enter the data model, and I can edit the DAX function. but It still doesn't update!!
My goal is to show the last 5 years in the report. But I don't know why it doesn't update to the current year.
This is the function and the model:
Thank you for any suggestions 🙂
P.D.: In case it helps anyone who is confused like me, in order to access the data model you have to activate the option. And it is managed by the admin of the space
HI @Cyberflor,
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!
UPDATE post !!!!!
I have managed to enter the data model, and I can edit the DAX function. but It still doesn't update!!
My goal is to show the last 5 years in the report. But I don't know why it doesn't update to the current year.
This is the function and the model:
Thank you for any suggestions 🙂
P.D.: In case it helps anyone who is confused like me, in order to access the data model you have to activate the option. And it is managed by the admin of the space
HI @Cyberflor,
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 32 | |
| 19 | |
| 12 | |
| 10 |