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
SergioHB's avatar
SergioHB
Helper I
3 years ago

Thanks v-yueyunzh-msft 

What I'm asking is exactly this ".. you can limit the data to import in Power Query Editor by some M code .And you need  a Year or Date column to filter the data you want.."

 

I do have a Calendar table with relation to the issues table hence, could you share how that code should look like?

 

Thanks in advance
Sergio

  • 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