Cancelled API and historic data in power query

[tomerbi]

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. 

[Idrissshatila · Accepted solution]

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.

[Idrissshatila · Accepted solution]

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.

[Idrissshatila · Accepted solution]

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]

Hi @Idrissshatila 

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 · Accepted solution]

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.

[tomerbi]

Hi @Idrissshatila 

Thanks a lot for your reply, I truly appreciate it. One more question though. It sounds like I won't be able to do anything to the cancelled API tables not even to merge into a new one. What can I do with that, like exporting into excel and import it again to make it function or do you have any suggestions/solutions? 

[Idrissshatila · Accepted solution]

Hello @tomerbi ,

yes, you could do that, this way you can do merge to it since it's now reading from excel.