Overcome the export limit of 150k rows from Power BI

Question

How can we overcome the PowerBi export limit?

• Link1
• Link2

Answer 1

Follow the measure to generate the measure for 201k Rows

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"

With R integration Place the following code

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) 

 If you want to learn more about Power BI then read Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.

You should also watch this video tutorial on Power BI: