Forum Discussion

NannaMi's avatar
NannaMi
New Member
10 years ago

Change excel data source in Power BI report

Hi,   Is it possible to change the excel data source by pointing at a new excel file, as I do not wish to overwrite the existing excel file, used as data source?   I have created a Power BI repor...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Yes, use the View | Advanced Editor and you should see a first two lines of something like:

 

let
    Source = Csv.Document(File.Contents("C:\temp\powerbi\dates.csv"),[Delimiter=",", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None]),

Edit the path of your file and you should be in business.