Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone ,
I would like to append the same table starting from the limit settled before ;
""OFFSET"": ""0""
""LIMIT"": ""55""
Offset 0 to limit 55 the table give me first 55 rows ;
then aappending at the same table 56 to 110 ; so offset 55 and new limit 110 ecc.
Just because is crashing uploading all the table at the same time .
Could someone help me ?
Thank you in advance
Thank you for the answer but I need to append the same table without modify manually the code ;
I would like to have a routine that could update the appending itself
Thank you in advance
try incremental refresh. With the incremental refresh, there are some issues.
Please note, this method allows Power BI to load data in a more manageable way, but you will still have to manually update the Offset and Limit parameters each time you want to load more data into your table. Also note that the Incremental Refresh feature is only available for Power BI Pro or Power BI Premium users.
Proud to be a Super User!
Hi, @karl184
In Power BI, you can achieve the same result by using the Power Query Editor to apply the OFFSET and LIMIT functionality. Here's how you can do it:
Open your Power BI report and navigate to the Power Query Editor. You can access it by clicking on "Edit Queries" in the Home tab.
In the Power Query Editor, select the table you want to append data to.
In the Home tab, click on "Advanced Editor" in the "Home" section. This will open the advanced editor window.
In the advanced editor window, you need to modify the M query code to include the OFFSET and LIMIT functionality. Here's an example of how you can do it:
Update the offset and limit values as needed for each batch. For example, for the second batch, you would change offset to 55 and limit to 55.
Click on "Done" to save the changes and close the Power Query Editor.
By modifying the M query code, you can apply the OFFSET and LIMIT functionality to retrieve data in smaller chunks and append it to your table in Power BI.
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.