Forum Discussion
ccianci
3 years agoFrequent Visitor
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...
danextian
3 years agoSuper User
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