Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks keeganm! I have actually been using that method for a while now also with the aid of the pdf guide Adaptive support sent me. Just an fyi, api v19 and above supports fetching data from modeled sheets.  Guide is available on the updated documentation for the api from Adaptive's website.

 

If you don't mind me asking, do you use Adaptive as a PBI data source?

 

 

Best regards,

 

Ferdinand

  • keeganm's avatar
    keeganm
    Frequent Visitor
    6 years ago

    Yes, we are just starting to use it as PBI source via the Adaptive API. The xml coding is a little annoying to work with, but I am finding it makes for a much faster data export method.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Cool! Just a word of caution though. In January this year, when Adaptive released an update, it broke my api pulling data from a modeled sheet. It got fixed about a couple of months later. Fortunately I have a workaround which was to extract the data by downloading the modeled sheet into excel and just applying a bit of ETL in Power BI. But since that dreadful event, I stopped using the api for modeled sheets. I only use api in my dataflow that downloads the levels, accounts, and some dimensions with attributes. So far, that dataflow has been pretty stable, scheduled to refresh 8 times a day. For the rest of Adaptive data, I rely on report templates to get preformatted excel output.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I've tried using the code in this post, but I keep getting the following error.  I've entered my credentials but I'm unsure if there are any other edits I need to make.  Could you please help me out?

         

        Expression.Error: The column 'output' of the table wasn't found.
        Details:
        output