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.
Hi All,
I am very new to Power BI.
I marged two sets of data and saved as new. (relathionship seems ok so they are able to combine)
I can see it in query view but when I return to data view, it is empty.
What I am doing wrong!?!?
Help!
Hi @cocomy,
When you have done all operation in query editor, you need to click "Apply" or "Close&Apply"(the query interface will be close if you click this) to save your operations, then Power Desktop data view will show the changes. Have you saved the changes by the button highlighted in red circle below?
Best Regards,
Angelia
Hi Angelia,
Thank you for your reply. Yes, I did close & apply.
Two sets of data are so different in format. (I can not change them as those files are managed by someone else)
For example...
Table A's country name.... USA, UK
Table B's country name... America, England
So I created table C to match both name
Then create relationship and query
(1) A+C Query ⇒ visible in data view
(2) B+C Query ⇒ visible in data view
Then finally merge
(3) A+B+C Query ⇒ can not see in data view
Is it possible it is because they are query's query? Appreciate if you could help.
All the best,
cocomy
Hi @cocomy,
Could you please share your .pbix file for further analysis?
Best Regards,
Angelia
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |