Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
2 | |
2 | |
2 |