I would like to compare the mRNA expression of different genes between tumoral samples and their paired normal samples in TCGA cohorts using cBioPortal. I'm just able to find data from tumoral samples.
cBioPortal is exclusively tumour samples. I don't know why the adjacent normal samples are not included but I suspect it is related to the fact that many of the tumour samples are not matched with adjacent tumours.
If you want just a quick visualisation of the differences, try this tool http://maplab.imppc.org/wanderer/. It has DNA methylation and RNA expression. You can also download the data.
Alternatively, download the data from the ICGC data portal https://dcc.icgc.org and do local analysis.
I agree with the above answer. Although the Wanderer tool is quite easy, it will give you less number of samples. Nevertheless, it is quick. You may further go to UCSC XENA browser and download the data. Using EXCEL you will easily sort the paired samples and use it.