topic Disconnect source but keep the table in Developer

Disconnect source but keep the table

samnaw — Tue, 21 Apr 2020 19:00:03 GMT

Hello:

I have an issue where I have a xls sheet that I am connecting to. But this xls is on my desktop and I dont want it connected. I just want a table in PBI that is stand alone.

Power Query

let
Source = Excel.Workbook(File.Contents("\\abc\abc\Desktop\Copy of Acc.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Cust_PrefStore", type text}, {"Nbr of New Loyalty Customers", Int64.Type}})
in
#"Changed Type"

------------------------------------------------------------------------------------

I dont want it linked. ("\\abc\abc\Desktop\Copy of Acc.xlsx"). Is this possible

Re: Disconnect source but keep the table

michaelx2 — Wed, 22 Apr 2020 02:04:39 GMT

Hello @samnaw

You may use 'Enter data' to create a table, copy the content from excel and paste the content to the table.

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("{encrypted string}", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Project = _t, StartTime = _t, EndTime = _t, Labor = _t, Note = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Project", type text}, {"StartTime", type datetime}, {"EndTime", type datetime}, {"Labor", type number}, {"Note", type text}}) in #"Changed Type"

Best Regards

Re: Disconnect source but keep the table

Mycall65 — Tue, 04 Feb 2025 07:32:44 GMT

That won't work unless you have fewer than 3000 cells to upload