Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Get XML data into Paginated report

I am able to get an XML data into a report by creating a data source as Enter Data and providing an API endpoint

http://localhost:5000/endpointname

that returns xml data. After creating an empty dataset I can assign fileds from my data to report components. One thing doesn't work. In the data source I only can use localhost, computer name or an IP dont work. Which obviously is not going work in published reports. Any idea?

 

Thanks

Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    No. Create the data source on the desktop, publish to the workspace, then connect to the dataset from Report Builder.

9 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    I assume you are on Premium capacity. Create a dataset based on your XML data and then consume that dataset from Report Builder.

    • Markzolotoy's avatar
      Markzolotoy
      Icon for Impactful Individual rankImpactful Individual
      5 years ago

      lbendlin Which data type should I select to create an XML dataset? All I see is XML files. I actually found it. I am using Web. But it's the same problem. It only works with localhost. If I provide a computer name I get:

      DataSource.Error: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
      Details:
      https://computernmame:5001/runNodeScriptGet

  • Markzolotoy's avatar
    Markzolotoy
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    lbendlin <Create a dataset based on your XML data. 

    Do you mean here?

    I am not suere whre to go from here to APIs.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    No. Create the data source on the desktop, publish to the workspace, then connect to the dataset from Report Builder.

    • Markzolotoy's avatar
      Markzolotoy
      Icon for Impactful Individual rankImpactful Individual
      5 years ago

      lbendlin OK, I have done it. I have created a dataset in PBI desktop and published it. I see that the dataset gets correct data. I added this dataset to my paginated report in PBI Report builder where it shows correct data. However, the same image object that woks fine in SSRS builder is not showing the actual image in PBI Report builder. I am getting the red X. Published version is not working either. It complains about data source not found.  Dataset in report looks like this:

      Image source is:

      =Convert.FromBase64String(First(Fields!body.Value, "DataSet1"))

      I put textbox next to image and assigned the same field to it. Here is what it shows:

       

       

      Any idea?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    datasets are always (expanded) tables. So you need to compromise, and convert yor XML into some sort of a table format by ingesting the XML in Power Query and then parsing it. No way around that.