Forum Discussion
How to load additional table from some one PBI file ?
Hi All
Some one have add below line to my PBI file , this have create a RATE table to my PBI file :-
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCglW0lEyVIrVATI9QUwDIIBwHREyAUCmsVJsLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [SOURCE = _t, RATE = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"SOURCE", type text}, {"RATE", Int64.Type}})
in
#"Changed Type"
May i know how he can load this RATE table to my PBI file. My PBI file have load many in many table from sharepoint. i just wondering how can he add in new table , as he don't have access right ?
Paul
@Paulyeo11, double-click the source in the power query on the right side and check what it shows.
Anonymous , Check the box on right on top of source
5 Replies
- amitchandak
Super User
@Paulyeo11, double-click the source in the power query on the right side and check what it shows.
- Fowmy
Anonymous
In Power Query, under the Home tab, click New Source then Blank Query.Right-Click the new query created and select Advanced Editor, clear what is already there and paste your code.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
