Forum Discussion

tomerbi's avatar
tomerbi
Icon for Helper I rankHelper I
2 years ago
Solved

Cancelled 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 contract...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    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's avatar
    Idrissshatila
    2 years ago

    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's avatar
    Idrissshatila
    2 years ago

    Hello tomerbi ,

     

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

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

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's avatar
tomerbi
Icon for Helper I rankHelper I
2 years ago

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's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    2 years ago

    Hello tomerbi ,

     

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