Forum Discussion

Joe_in_Baltimore's avatar
Joe_in_Baltimore
Copper Contributor
Nov 28, 2021

CSV import into office 365 data model

How do I set up an ODC to import a csv file from the current working directory (i.e., without having to specify specify the full file path, just the name of the current working directory)?   Thank ...
BI & Data Analysis
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 29, 2021

Martin_Weiss 

As a comment, Ignore privacy settings is a common practice, however better to avoid if possible. The workaround could be

let
    Source = Excel.CurrentWorkbook(){[Name="Source"]}[Content]{0}[Column1],
    SourceCSV = Csv.Document(
        File.Contents(
            Source & "DataSource.csv"),
            [Delimiter=",", Columns=11, Encoding=65001, QuoteStyle=QuoteStyle.None])
in
    SourceCSV
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Nov 29, 2021

Hi SergeiBaklan 

thanks for your solution, I really like it.

I was never very happy about ignoring the privacy settings, but did not found a proper solution. So your proposal is really appreciated.

 

Thanks a lot!

 

Resources