Export data from Power BI to SQL Server overcome the limit of 150k rows

Question

How can I over come the Power Bi export limit to 150k rows?

Answer 1

Use the following measure

let
    Source = List.Generate(()=>1, each _ < 201001, each _ + 1),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    #"Converted to Table"

library(RODBC)
conn <- odbcDriverConnect("driver=SQL Server;server=.\\SQLEXPRESS;Database=MyDataBase")
odbcClearError(conn)
sqlSave(conn, dataset, tablename="MyR_table",rownames=FALSE, safer=FALSE, append=FALSE) 

close(conn) 

Want to learn more about Power Bi, Refer: Power Bi Training