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,
I have got 2 spreadsheets (datasets) with a common theme betwen them, that is, a common column. Is Power BI able to connect to the 2 spreadsheets at the same time to show the data on one Report?
Thanks,
Abi
Solved! Go to Solution.
Yes, you could either import both spreadsheets and then relate them to one another or do a Merge query in Power Query.
Yes, you could either import both spreadsheets and then relate them to one another or do a Merge query in Power Query.
Hi Greg,
Thank you very much for the solution. It worked.
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.