Forum Discussion

srana's avatar
srana
Frequent Visitor
4 years ago

Not able to load data in powerbi

Hi team,

I am pulling my data from Sybase server(Rapid Sql) through odbc. 

I have only 4 views. 

1 view consists of 164441 rows, 2nd view- 218647 rows, 3rd view- 241572, 4th view-264895 rows.

After merging these in transform data and applying it, the report is not loading the data after 867114 rows. What to do??

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    srana Wait. Complex transformations can take a considerable amount of time. You might want to consider creating a view on the server that performs the necessary joins as this should be significantly faster.