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.
Is there any way to "connect" to an excel, without having to import the data into the pbix file? in other words- having a live connection (similar to SSAS) to an excel sheet, where no data is stored in the pbix, and the user credentions are used to query live.
I don't believe in the way that you are referring to. If your file is on OneDrive, you have the option to import or connect, but it is not really "live" connection to the data like what you can do to a SSAS tabular model.
ok. so for onedrive- whats the difference between import or connect?
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.