Forum Discussion

SergioHB's avatar
SergioHB
Helper I
3 years ago

JIRA Content Pack Data Refresh

Hi,   I have a PBI dashboard connected with JIRA which sync issues of my organization. The thing is that, it's running now for over 4 years and the 'Refresh Data' is taking too long to refresh so I...
Need Help
Show and Tell
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , SergioHB 

The Calendar table may not limit the other table import in Power Query Editor, you need to filter the data in the isssue table to reduce the data importing to the desktop.

For this you can refer to :
Filter by values in a column - Power Query | Microsoft Learn

Learn How to Filter Records Using Power Query (yodalearning.com)

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

SergioHB's avatar
SergioHB
Helper I
3 years ago

v-yueyunzh-msft 

That filtering is once the data is into my pbi. What I need is to apply that filter during the 'Refresh Data' process? Is it possible adding this into it?

 

Thanks

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi,  SergioHB 

    When the dataset refreshes, it will execute the M code to get the data and then get the data to refresh the dataset.

    The first method for reduce the refresh data is that you need to filter the data in .pbix file  and then you need to republish the .pbix file to Power BI Service.

    The second method needs to have a premium or ppu. You can use SSMS connect to the Power BI workspace by the XMLA.

    For this you can refer to :

    Dataset connectivity and management with the XMLA endpoint in Power BI- Power BI | Microsoft Learn

    Then we can go to the Tables' Partions.We can configure the partitions we want to refresh the data we need.We can also have one more partitions to realize the different need.

    We can modify the partition in it like this:

    Then we can just refresh the data we want in this partition.

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

     

     

     

     

    • SergioHB's avatar
      SergioHB
      Helper I
      3 years ago

      Thanks for the detail reply v-yueyunzh-msft but in my case I'm just using PowerBI Desktop with Content Pack. I'm not using PowerBi Service nor any other premium service..

       

      Not sure if this can be achieved using this.

       

      Thanks anyway
      Sergio

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Community Support
        3 years ago

        Hi , SergioHB 

        Oh, according to your description, you refresh the data in Power BI Desktop.

        If this , you can just filter the data you do not need in Power Query Editor .

        The steps in Power Query is reading the data and do some transformation , when you refresh in Power BI Desktop , the steps in Power Query will do the work and then apply the data to Desktop. If there is less data in Power Query, it will also reduce the refresh time to some extent.

        For this , you can refer to this case:
        Solved: Data source filters in Power BI - Microsoft Power BI Community

         

         

        Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

         

        Best Regards,

        Aniya Zhang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly