Problem with filters in Power Bi service

Hi ponchibonosrzt,

Thank you for reaching out to Microsoft Fabric Community.

Thank you anilelmastasi for the prompt response. 

Since the report works correctly in the desktop and after publishing, but changes only after the dataset refresh in the service, so this looks like a data integrity issue during refresh, not a visual filter issue.

This can happen if the relationship key changes after refresh. Since your source is Google Sheets, please check the following:

• Make sure the column used in the relationship does not contain duplicates after refresh (particularly on the ‘one’ side).
• Check for blank values in the key columns and remove them if any.
• In Power Query, explicitly set the data type of the relationship columns (do not rely on automatic detection).
• Apply Trim and Clean to the key columns to remove hidden spaces.
• Remove any completely empty rows coming from the sheet.

Even if the relationship still shows as 1-to-many, if duplicates or blanks appear in the key after refresh, filter propagation will not behave correctly.

After applying these steps, refresh in desktop and republish then trigger a service refresh again.

Thanks and regards,

Anjan Kumar Chippa