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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I'm currently facing a weird issue with my reports online. Some Infos about the report:
Two tables (csv and OBDC), linked m:n with one header, bidirectional filter and two pages
So here's the problem:
When modifying my slicer, (adding the option to select the calendar week for the current month) it works as designed in edit mode. However, when the changes are saved and the user tries to select the calendar week, it will be displayed correctly only on one page.
Now, my last guess would be, that this is a bag due to the recent update...
Any thoughts on this?
Page 1 [not working]
Page 2 [working]
Solved! Go to Solution.
[update]
So today I finally got an error message while publishing a report:
The remote server returned an error: (500) Internal server error
To remove this, I used the instructions in Re: The remote server returned an error: (500) Int... - Microsoft Fabric Community
While removing the cache, i noticed, that the report had a 34GB data cache!!
When having this issue in a pipeline, delete all semantic models before uploading/deploying in the next stage.
Now my report works perfectly fine
[update]
So today I finally got an error message while publishing a report:
The remote server returned an error: (500) Internal server error
To remove this, I used the instructions in Re: The remote server returned an error: (500) Int... - Microsoft Fabric Community
While removing the cache, i noticed, that the report had a 34GB data cache!!
When having this issue in a pipeline, delete all semantic models before uploading/deploying in the next stage.
Now my report works perfectly fine
Hi,
As you mentioned on one page you have a CSV table and on another page, you have an OBDC table.
It seems that you have created a custom Date table and field to filter the data based on the calendar week so could you please make sure that you have created a relationship of both CSV and OBDC tables with the date field of the Date table so filtering works properly on both the pages?
Or could you please share a sample .pbix file so can check and try to resolve the issue?
Hi @SamInogic
sorry for the missunderstanding. Both tables are used per page and there is no custom date table. In fact the dates & calendar weeks, which they are listed in the .csv file, link both tables is through a key.
Maybe I haven't described my problem that much in detail.
When working in PBI deskop, the slicer works correctly (select the calendar week and month).
But if the report gets published, it does this weird inconsitency (Being only able to select a month).
What's weird is, that all the fields in the slicer are from the same table, but the slicer works on one page and on the other not...
Also I must inform you, that I can't be able to share the .pbix file due to sensitive data.