Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Getting error while refreshing PBI desktop -After extracting some records-start again from 1- why?

Hello Folks,

I am facing an issue for last 3 days while refreshing data from SQL server at my local desktop dashboard .

After extracting some data like 10 lacs + records from server to Desktop power bi, again starting from 1. It is coming for last 3 days

 

In below snapshot, Data is retrieving from server on all table but the Table "DB_CSC_DATA Yield_Sec_Test" is getting restart from 1 after completing the 10 lacs+ records 

I am extracting this data on VPN.

What should I check to resolve this issue 

Please suggest .

Thanks in advance.

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    It got resolved by me as it was due to internet issue at my wifi

2 Replies

  • mhossain's avatar
    mhossain
    Solution Sage

    Anonymous 

    Table "DB_CSC_DATA Yield_Sec_Test" - Have you created some steps in the powerquery? What kind of steps you have created? Or this is just simple extraction from your database.

     

    "DB_CSC_DATA Yield_Sec_Test" and "DB_CSC_DATA Yield_Sec_Test1" - Are these the separate tables in your database? Or you are making duplicates in powerquery?

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    It got resolved by me as it was due to internet issue at my wifi