How to debug a power BI connector?

Solution 1:

This may have been solved already given the time elapsed since asked - but you're missing a comma between the last two lines of your let statement:

    Dataset_csv=Csv.Document(My_Dataset) //<------ here
    Dataset_csv_with_header=Table.PromoteHeaders(Dataset_csv)