Crossing social media data into a table via Power BI

[Anonymous]

Hello, everyone

So i've been having a problem with storing and managing data in Spreadsheets when extracting a great number of data from each channel (i'm considering FB, IG, YT and TT) via Supermetrics and normalizing them into one big Dashboard spreadsheet - generally it becomes too heavy because of the formulas and my dashboard breaks.

Since this has been happening, i've been trying to import the separate sheets for each channel (FB, IG, TT, YT and my Media Plan) into Power BI and crossing the information inside the tool using a Key - that is basically composed by "Campaign&Channel&Format" - in order to identify the information and cross it.

However, when i put my info togheter in a table or graph it shows me different columns with the same label for "Clicks", for example, when i add my Channel segmentation - in this case, 4 different "Clicks" columns, one for each channel.

My question is: is it possible to import separate channel sheets into PowerBI and normalizing them inside the tool in order for it to bring me these data in a single "Click" column instead of a separate one for each channel?

Thanks for the attention

[v-cherch-msft · Accepted solution]

Hi @Anonymous

It seems you may try to use 'Append queries' to combine the spreadsheets.Here is the document about this feature.If it is not your case,please share some screenshot about the data and explain more about your expected output so that we could help further on it.

Regards,

Cherie

[v-cherch-msft · Accepted solution]

Hi @Anonymous

It seems you may try to use 'Append queries' to combine the spreadsheets.Here is the document about this feature.If it is not your case,please share some screenshot about the data and explain more about your expected output so that we could help further on it.

Regards,

Cherie

[Anonymous]

Great!

It worked out perfectly, thanks a lot (:

[v-cherch-msft · Accepted solution]

Hi @Anonymous

Glad to hear the reply is helpful, please accept my reply as solution, that way, other community members will easily find the solution when they get same issue.

Regards,

Cherie