Forum Discussion
combining data
Just a quick background - I'm pulling Service Now data via a Power BI connector and reporting ticket details for various IT teams/departments in my company. Our "digital solutions" team is no longer using Service Now and has recently switched to Jira to log their tickets. I have access via their SQL databse so i'm pulling the data I need.
In my existing PBI report, i have a line chart that plots the number of tickets over the last 18 months and I have a slicer for each team. The issue, now, is that since they switched to using Jira, I can no longer use that slicer because after May 2023, I need plot the data using the SQL data source. Screnshot below to explain what I'm talking about. As you can see, the data cuts off after May '23. I know I can create a new line chart just for this team but it's more convenience to keep using the same slicer.
Any clever tips, or is this even possible at all, to continue using the existing slicer so it keeps plotting new data after May '23? I can't combine the SQL data with the Service Now data as they have vastly different columns, etc...
2 Replies
Hi ccianci ,
Have you tried appending the JIRA table to your ServiceNow table. Append basically creates a union of two or tables. Just make sure that you have the same column names. https://support.microsoft.com/en-au/office/append-queries-power-query-e42ca582-4f62-4a43-b37f-99e2b2a4813a
You need to disable Enable load for Jira so it doesn't get loaded to your model. It just sits in Power Query.
https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up
thank you. I have not tried that yet because the columns dont match at all. I can see what i can do about manipulating the data to make them match. I'm OOO for a few days so I'll give this a try next week.
