The SharePoint site contains folder like structure say year/month/date in that (list of files) and files are incrementally added every day so how to load the data in same format in Fabric Option 1: By creating a connection( with tenant details) using copy data can able to load only the schema of the files in the lakehouse not the physical tables Option 2: Using the dataflow gen2 failed to run the query as the data for the one month is more then 5GB Please suggest an optimise way to connect SharePoint of fabric

I spy with my little eye...

Hi! Is it possible to create hierarchy in fabric lakehouse tables ? Appreciate your help and attention.

Hi I built a semantic model in fabric on Lake House, I have a date table for which I was expecting to see Date hierarchy but I don't see one and I don't have an option to add hierarchy in on the table in semantic model, is this not possible with fabric? Thanks Suresh

Is it possible to use across workspaces data destination for Warehouse in Dataflow Gen2 ? How to do it? I have a user that needs to get data from a table in my workspace, if i use copy data, the data is not in overwrite mode, is it possible to do it in copy data activity?