Forum Discussion

IgorCanabarro's avatar
IgorCanabarro
Regular Visitor
5 years ago
Solved

SQL table buffer

Hello, I am having difficult to set up a buffer to a merged table from SQL server. The table has more than 600k lines and  I need to merge info with a csv table I work on.   I have tried the follow...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi IgorCanabarro ,

    a buffer won't help you for that, because it would drag the data anyway once your refresh the pbix (or in the service).

    If your SQL has different refresh intervals than the csv and your SQL-table is filtered, then moving to a dataflow for your SQL import could improve. But not sure with your table length. You can set a different schedule there and then import it to PBI to merge with the CSV.
    Do your sources live in in the cloud already? Then moving everything to a dataflow could also be a solution, especially if limited resources on your PC or slow internet connection are the reason for slow refresh.

     

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
5 years ago

Hi IgorCanabarro ,

a buffer won't help you for that, because it would drag the data anyway once your refresh the pbix (or in the service).

If your SQL has different refresh intervals than the csv and your SQL-table is filtered, then moving to a dataflow for your SQL import could improve. But not sure with your table length. You can set a different schedule there and then import it to PBI to merge with the CSV.
Do your sources live in in the cloud already? Then moving everything to a dataflow could also be a solution, especially if limited resources on your PC or slow internet connection are the reason for slow refresh.