Forum Discussion

ponchibonosrzt's avatar
ponchibonosrzt
Frequent Visitor
6 months ago
Solved

Problem with filters in Power Bi service

I am having an issue with a filter and a table in Power BI Service.
I am working on a project that contains two tables stored in Google Sheets. When I work on the project from my desktop, the filters work correctly. When I upload my project to the Power BI cloud, it also works fine. The problem arises when I update the data from the Power BI cloud. The filter for the table stops working correctly. I have already tried several things, such as verifying that the data has a designated data type, that the relationships between the tables are “one to many,” and that the data comes from the same data table as much as possible.
When I use the filters on the desktop

Only one row appears in the table, which is correct.

 

 

When I use the filters in the Power BI cloud.

The table shows many results, which do not correspond to the information in my data.

Here is the pbix file

 

 

And the link to the dashboard in the PowerBi cloud
https://app.powerbi.com/view?r=eyJrIjoiODA3MGY2NjUtOGQwMy00NzA1LWE2Y2UtODcyMjZhMDgxMWY2IiwidCI6IjYyMDI0ZDNlLTdjY2UtNDYxNC1hODIzLWViNTkzNGM3ODAwZSJ9

 

I have already tried several things and cannot resolve it. I  appreciate any assistance.

Thank you in advance.

 

 

 

 

Need Help
  • v-achippa's avatar
    v-achippa
    6 months ago

    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

     

     

5 Replies

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    6 months ago

    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

     

     

    • v-achippa's avatar
      v-achippa
      Icon for Community Support rankCommunity Support
      6 months ago

      Hi ponchibonosrzt,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution i have provided for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Icon for Community Support rankCommunity Support
        6 months ago

        Hi @ponchibonosrzt,

         

        We wanted to kindly follow up to check if the solution i have provided for the issue worked? or let us know if you need any further assistance.

         

        Thanks and regards,

        Anjan Kumar Chippa

    • ponchibonosrzt's avatar
      ponchibonosrzt
      Frequent Visitor
      6 months ago

      Hi  anilelmastasi thanks for your message.

      The activated filters are only those that are selected and highlighted in the image. None that do not correspond appear.

       

      Thanks in advice