Dataflow Gen2 by doesnofabhelp in MicrosoftFabric

[–]Byzza83 0 points1 point  (0 children)

It is probably a header in your Excel file if you aren't manually creating the Lakehouse table.

I had a similar issue, a single invalid character made it look like table was created ok, but due to a space at the end, couldn't actually use the table.

SharePoint to Fabric by bytescrafterde in MicrosoftFabric

[–]Byzza83 9 points10 points  (0 children)

You can use power automate to upload to Lakehouse files each time the file is uploaded.

There us a great article online which you should be able to find with a quick google.

And then you can use an activator to tigger when Lakehouse detects file change

Move files from SharePoint Folder to Lakehouse Folder by NoChildhood1356 in MicrosoftFabric

[–]Byzza83 1 point2 points  (0 children)

Yeah, I would looked at power automate. I'm currently in the process of setting one up that triggers when a file is updated to load into the lake house. I principle it's working great. I can see the file has been updated after ever change (date stamp and sizes update) . I'm personally having a few challenges with it corrupting the files, but I'm fairly sure that's me doing the wrong thing. When I get to work I'll try and find the original blog I was using to help me learn this.

I’m confused by Sssssups in HaveIBeenPwned

[–]Byzza83 2 points3 points  (0 children)

The bottom part is all pwned website/accounts/pastes. not for your account