Blob container of incoming Parquet files as one source?

[simonGIS]

I need some help with a workflow.

• Paraquet files in a public Blob Container
• Every hour, new file appears in the folder
• Every file has same schema
• Need a PowerBI report that references all Paraquet files as a single source.

If I add an Azure Blob Storage container as a container and load, I only get the metadata for the files and not the actual schema/data.

If I try adding a folder of the files on my local drive, it lets me combine the files into a single data source query.  I need to achieve the same with the files in the Blob container.

What is the best approach for me to have Powerbi reference this blob container and treat the parquet files as a single data source for my visualisations?

[Anonymous]

Hi @simonGIS ,

You can refer the following links to connect it in Power BI Desktop:

Power BI Quick Tip: ​Using Parquet File as a Source

CAN POWER BI READ PARQUET FILES?

Power BI reading Parquet from a Data Lake

Workaround for reading Parquet files in Power BI

Best Regards