Can I add script to power quarry to load X row data only ?

[Anonymous]

Hi All

i like to know am I allow to write some script insert into M CODE section to limit load only 9 row of data to PBI. 

So I can use that for testing purpose.

Paul

[Adamtall · Accepted solution]

Hi,

you can use "keep top rows" 

type this code in a blank query "advanced editor"

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wcs7PLchJLUlV0iGPGauDYgYxetH1kG0vmrHotuN3G43chMPLcITpbkxlWP1G47DE5yCiwxSPG1ECAdnuWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Brand Completeness" = _t, #"SC Franchise Completeness" = _t, #"Commercial Franchise Completeness" = _t, #"Varient Completeness" = _t, #"ShelfLife Completeness" = _t, #"Medically Critical completeness" = _t]),
#"Kept First Rows" = Table.FirstN(Source,9)
in
#"Kept First Rows"

/Adam

[Adamtall · Accepted solution]

Hi,

you can use "keep top rows" 

type this code in a blank query "advanced editor"

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wcs7PLchJLUlV0iGPGauDYgYxetH1kG0vmrHotuN3G43chMPLcITpbkxlWP1G47DE5yCiwxSPG1ECAdnuWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Brand Completeness" = _t, #"SC Franchise Completeness" = _t, #"Commercial Franchise Completeness" = _t, #"Varient Completeness" = _t, #"ShelfLife Completeness" = _t, #"Medically Critical completeness" = _t]),
#"Kept First Rows" = Table.FirstN(Source,9)
in
#"Kept First Rows"

/Adam

[Anonymous]

Hi Sir

how to ask PBI only load 70 row ?

[Adamtall · Accepted solution]

Hi, 

Depends if it is a Database? 

then you can have a sql query:

like this:

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

select top 70
[$Table].[timestamp] as [timestamp],
[$Table].[Exclude from Accrual Report] as [Exclude from Accrual Report]
from [dbo].[EQM$G_L Entry] as [$Table]

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

or: 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wcs7PLchJLUlV0iGPGauDYgYxetH1kG0vmrHotuN3G43chMPLcITpbkxlWP1G47DE5yCiwxSPG1ECAdnuWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Brand Completeness" = _t, #"SC Franchise Completeness" = _t, #"Commercial Franchise Completeness" = _t, #"Varient Completeness" = _t, #"ShelfLife Completeness" = _t, #"Medically Critical completeness" = _t]),
#"Kept First Rows" = Table.FirstN(Source,70)
in
#"Kept First Rows"

/Adam

[Anonymous]

Hi Sir

thank you for your sharing .

i am load by CSV or TXT format 

paul