In Data Factory I am trying to set up a Data Flow to read Azure AD Signin logs exported as Json to Azure Blob Storage to store properties in a DB. The problem arises when I try to configure the Source side of things. No matter what I try to set as wild card, I keep getting a "Path does not resolve to any file(s). Please make sure the file/folder exists and is not hidden.".
I use the Dataset as Dataset and not Inline. I can click "Test connection" and that works. In the Source Tab and on the Data Flow screen I see that the columns (15) are correctly read from the source and even that the properties are mapped correctly, including the complex types.
The actual Json files are nested 6 levels deep in the blob store. Is that an issue?
I've tried all kinds of wildcards:
None of it works, also when putting the paths around single quotes or when using the toString function.
Does anyone know if this can work at all?