Forum Discussion

wchung's avatar
wchung
Frequent Visitor
9 years ago

Automate Daily Snapshot and Trend Graphics

Hi,   I'm building an investment dashboard that combines stock inventory (excel) with Yahoo finance stock price (web) to calculate the net market value of each day. This is refreshed daily after th...
Need Help
Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Hi, 

 

Right now in power BI can't support the schedule refresh with combine some type data source in single dataset.

 u have to check that first.

 

 

Then u can create auto refresh for web also in gateway setting . pls check that too.

 

 

 

 

 

 

 

wchung's avatar
wchung
Frequent Visitor
9 years ago

Hi Baskar,

 

The refresh is working alright for me. I'm using personal gateway to connect to file stored in one drive as a workaround so technically they are both web source. I learned that through the community ;-)

 

Any advise on storing the daily data?

 

Thanks!

 

 

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    My suggestion is please go with SSIS 

     

    create one package and store data in SQL Table on daily or houtly basic .

     

     

    That will help u 

    • wchung's avatar
      wchung
      Frequent Visitor
      9 years ago

      I see, I have no knowledge in SSIS but I'll look into it!

       

      Thanks for the comments!

      • Baskar's avatar
        Baskar
        Icon for Resident Rockstar rankResident Rockstar
        9 years ago

        welcome dude