Forum Discussion

cbailiss's avatar
cbailiss
Advocate II
10 years ago

REST API and Power BI Desktop

Hello   I have successfully used the REST API to create a new dataset, table and have added rows to the table.   If I create exactly the same dataset in the Desktop tool (i.e. same dataset name, ...
Need Help
fso's avatar
fso
Advocate II
10 years ago

I have found the same limitations (no DAX measures + can only write to datasets that were created via API). As a workaround I have pushed the data to Google Drive instead and PBI is grabbing the data from there. But as you mentioned, this does not support real-time updates, which is a shame.

  • MbProg's avatar
    MbProg
    Helper II
    9 years ago

    Yes, I think this feature is so elementary.  I don't understand why it is not available in Power BI.

    fso The way you use with google drive, do you have such kind of regulary updates? I mean a real time update?

    • fso's avatar
      fso
      Advocate II
      9 years ago

      @MbPro yes you do, kind of.
      Google Apps Script allows you to set triggers (every minute, hour, etc.) which work just like cron jobs.
      But there is a limitation on the PowerBI-Side how often you can refresh per day.

      So you can schedule refreshs but to get "real time" you would probably have to use the PowerBI API instead.