Forum Discussion

fedpar's avatar
fedpar
Microsoft Employee
9 years ago
Solved

GET table contents through webapp

I'm looking to write a simple webapp that will go through a specific dataset's table and determine if the data is complete and up-to-date. I'd run this on a daily basis. I started looking into the Power BI API and noticed you can modify existing tables (e.g. add rows), but I see no mention of actually getting the existing rows. I went ahead and downloaded this Getting Started VS solution and it connects to my data source great and gets a list of all the datasets I have. Is there a way to obtain tables' rows using this API? If not, is there any other way to do so?

Need Help
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    fedpar Here's the list of all REST API operations. I think Add and delete rows could be what you're after. Also I it may not be possible to get individual row atm through API but you can submit that as an idea to be implemented in future.

  • fedpar's avatar
    fedpar
    9 years ago

    Hmm...there doesn't appear to be a way to read the data. Oh well, back to doing it manually, I guess. Thanks!

2 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    9 years ago

    fedpar Here's the list of all REST API operations. I think Add and delete rows could be what you're after. Also I it may not be possible to get individual row atm through API but you can submit that as an idea to be implemented in future.

    • fedpar's avatar
      fedpar
      Microsoft Employee
      9 years ago

      Hmm...there doesn't appear to be a way to read the data. Oh well, back to doing it manually, I guess. Thanks!