Forum Discussion

RonanSmyth's avatar
RonanSmyth
New Member
1 year ago
Solved

Dropdown Slicer

Hi there, I'm using a dropdown slicer to filter on customer name. This works fine in desktop but throws an error when published to service. The data is coming from a number of database tables. The ...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi RonanSmyth,

     

    Here the slicer working in the desktop. The same slicer logic works on other pages of the same report, the relationships and gateway are consistent. This could be a power bi service rendering or cache related bug, possibly specific to that page, visual or data volume. So I request you to please raise a support ticket in the Microsoft Fabric Community Forum.

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi RonanSmyth,

 

Thank you for reaching out to Microsoft Fabric Community.

 

The issue here is most likely related to the on premises data gateway configuration or the unsupported query transformations used for the Customer Name dropdown slicer.

  • Verify that your On-premises Data Gateway is online and all the connected data sources show a green check mark. If not reconfigure or restart the gateway service.
  • Confirm that the data source credentials are correctly configured and updated and the privacy levels are compatible in the service.
  • Simplify the power query steps for the Customer Name field to ensure query folding is supported. 
  • For now try using a basic slicer or convert the dropdown to a list slicer to check for any UI timeout issues.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi RonanSmyth,

     

    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.
    If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi @RonanSmyth,

       

      We wanted to kindly follow up to check if the solution I have provided for the issue worked.
      If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        1 year ago

        Hi @RonanSmyth,

         

        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.
        If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

         

        Thanks and regards,

        Anjan Kumar Chippa