We are using Azure Blob Storage as Input data source in powerbi. Inside blob container there are multiple folders and I need to load all files of a particular folder. This is my script to achieve:
let
Source = AzureStorage.Blobs("pratik"),
#"power-bi-reports1" = Source{[Name="power-bi-reports"]}[Data],
#"Filtered Rows" = Table.SelectRows(#"power-bi-reports1", each Text.Contains([Name], "response")),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each ([Extension] = ".csv")),
#"Expanded Attributes" = Table.ExpandRecordColumn(#"Filtered Rows1", "Attributes", {"Content Type", "Kind", "Size"}, {"Attributes.Content Type", "Attributes.Kind", "Attributes.Size"}),
#"Filtered Rows2" = Table.SelectRows(#"Expanded Attributes", each [Attributes.Size] > 0),
This was working fine. Recently we did some change in Blob CSV schema and Power BI Transformation and after that I am unable to apply/refresh in PowerBI Desktop. I keep getting this error:
OLE DB or ODBC error: [DataSource.error] AzureBlobs failed to get content from 'https://<>.blob.core.windows.net/power-bi-reports/output/response/1234/part000-2321-ff.csv'. Status code: 404, description: Specified blob does not exist
I am not getting why powerbi is looking for a specific file. Any input?
