Forum Discussion
Helper ICancelled API and historic data in power query
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.
Super UserHello 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.
- tomerbi
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?
