Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Merging Columns in Data Source

I am using a web data source for power BI (an API from our organizations database) and when it imports to PowerBI is columns are merged. Then when I try to expand the columns it's only giving me one ...
Need Help
Tutorial Requests
lbendlin's avatar
lbendlin
Super User
2 years ago

what's the output format of that API, JSON?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    XML

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      see if you can force it to output JSON instead (Header accept = application/json).

       

      Can you post sample data?