Forum Discussion
Helper IConnecting 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 at the raw XML data, I can see that it passes the data into PowerBI, but some of it is being masked by the word, "table" when I try to review it in the power query editor. Why is that!!??? This persists even after I change the data type to the most appropriate.
I'm having better days with PBI, but there are still simple hangups that make me feel slow or confused.
Thanks for your assistance:: PowerBI
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).
4 Replies
v-yanjiang-msftCommunity Support
Hi akee ,
Please refer to the similar thread:
PowerBI XML Data Source from REST API Call sometimes returns "table" data type - Stack Overflow
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
akeeGreetings--
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.
- v-yanjiang-msft
Hi akee ,
Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!
Best Regards,
Community Support Team _ kalyj- akee
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).