Forum Discussion

DarSz's avatar
DarSz
Helper I
5 years ago
Solved

Reference table and refresh

Hello, I have following problem.   Let's say I have table X in .pbix that contains 10k rows. For performance purposes I'm using incremental refresh, so on service this table contains around 500k ro...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    DarSz , Need to check this. But is it possible for you to do same in DAX ?

    X/

      S 

    Table1 = Table

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hello DarSz ,

 

what is your data source? And how big is your file size when you save it with all the rows included.

In general 500k rows should not be a problem for a database and also not for Power BI. So I would not implement an incremental refresh until there is a specific reason why you would use that.

 

Incremental refresh is made when you have tens of millions or billions of rows.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi

  • DarSz's avatar
    DarSz
    Helper I
    5 years ago

    My data source is SQL database and my file isn't that big. Problem is with publishing to BI service; when I duplicate table X and push my pbix, refresh ends with timeout.

     

    As for incremental I'm using it to reduce load at my database.