I'd like to be able to open csv files with PBI Desktop and have it understand that I want to create a pbix file using the csv file as a data source.
Bonus points if this works from a folder of csv files.
Gold star if this works from Powershell on a folder of csv files.