Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Hi Sir
how to ask PBI only load 70 row ?
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
Hi Sir
thank you for your sharing .
i am load by CSV or TXT format
paul
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |