Dear All,
I'm preparing a report which Budget Vs Actual comparison in Powerpivot. My Actual data comes from SQL server through Powerquery data loader by writting a sql query. But My Budget values are comes from Excel tables which saved my PC. I want to merge the power query output and my excel data together. Can someone share the ideas....SQL actual data refresh auto on daily basis...
Thanks
Suresh
I'm preparing a report which Budget Vs Actual comparison in Powerpivot. My Actual data comes from SQL server through Powerquery data loader by writting a sql query. But My Budget values are comes from Excel tables which saved my PC. I want to merge the power query output and my excel data together. Can someone share the ideas....SQL actual data refresh auto on daily basis...
Thanks
Suresh