Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Great!
It worked out perfectly, thanks a lot (:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |