How to load additional table from some one PBI file ?

[Anonymous]

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

[amitchandak · Accepted solution]

@Paulyeo11, double-click the source in the power query on the right side and check what it shows.

[amitchandak · Accepted solution]

@Paulyeo11, double-click the source in the power query on the right side and check what it shows.

[Anonymous]

Hi Amit

Kindly share a screen shot on where to click ? or you refer to below ?

paul

[amitchandak · Accepted solution]

@Anonymous , Check the box on right on top of source

[Anonymous]

Hi Amit

Thank you very much for your sharing 

Paul

[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 🙂

Website YouTube  LinkedIn