Forum Discussion

akee's avatar
akee
Icon for Helper I rankHelper I
3 years ago
Solved

Connecting Wufoo Form to PowerBI through api / xml / powerbi: Some values show as "table"

Hello all-- Just doing a simple API call from a Wufoo form into a Power BI file -- using Power BI's web option, along with a Wufoo Key and password. I get data, but not all of the fields.  Looking ...
Need Help
  • akee's avatar
    akee
    3 years ago

    The solution for me was to open the file first in MS Excel, which has a better XML handler than PowerBI.  And then, as it turns out, I ran back to MS Access to ultimately use the data anyway--rather than PowerBI as I was going to create a paginated report with it.  But I don't have, nor need to pay for the PowerBI premium license--just to create pagniated reports when I have more than ample skills to create the exact same report in MS Access (using XML/Wufoo exported data).

akee's avatar
akee
Icon for Helper I rankHelper I
3 years ago

Greetings--

Thanks for your answer.  Upon closer inspection, I think the issue involves broken containers.  I'm noticing, by looking more closely at the xml code in the file I'm importing that there are end containers, </field> without opening containers, <field>.  For whatever reason, I believe that is the source of the issue.  I'm about to experiment with that hypothesis.