Forum Discussion
Helper ICancelled API and historic data in power query
Hi,
First of all, I'm currently receiving data through URLs provided from one of the general contractor via the APIs. Now we are cancelling the contract with them and chnaging to another contractor instead. My question is that after the cancellation, of course we won't be able to retrieve the data from them anymore via their provided APIs but what will happen to the exisiting data that have been retrieved in the power query? Will I lose these data? What are the possibilities to manage/export or keep these data in any other format i.e. excel or table from power query?
Thank you in advanced.
Hello tomerbi ,
the data in Power bi will be reachable, because it is imported to power bi but you can't refresh the data or receive new data or do transformation in power query.
Hello tomerbi ,
you won't be able in power query to connect with the table related to the canceled kpis., it won't interact and it will give an error in it.
Hello tomerbi ,
yes, you could do that, this way you can do merge to it since it's now reading from excel.
5 Replies
- Idrissshatila
Super User
Hello tomerbi ,
the data in Power bi will be reachable, because it is imported to power bi but you can't refresh the data or receive new data or do transformation in power query.
- tomerbi
Many thanks for your response.
Is there any possbilities that I can export this in an excel format firstly beforehand?
As you mentioned that I won't be able to do the transformation in power query once it stops, will it still be possible to merge these data with the other APIs which I will be receiving from a new general contractor? And is there any chance to merge two tables i.e. the data is stored by date from top to bottom and merge the old/cancelled API data with the new one for instance.
- Idrissshatila
Hello tomerbi ,
you won't be able in power query to connect with the table related to the canceled kpis., it won't interact and it will give an error in it.
