Forum Discussion
Power BI online report not applying changes correctly
[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
Super UserHi,
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.