Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
10 years ago

Get data from webservice

I am trying to bring data into my dashboard by accessing a websevice endpoint. It works fine in my mobile report wher i am using a dataset based on an xml data source. After proving URL of that data ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi Markzolotoy,

 

In Power BI, the Web data source type is used for importing a table of data from a Web page. You can take a look at this article: Tutorial: Importing and analyzing data from a Web Page using Power BI Desktop.

 

In your scenario, as the web page doesn't contain any table data, you only retrieve element data in Query Editor. I would suggest you use XML data source instead of Web URL to retrieve data.

 

Best Regards,
Qiuyun Yu

Markzolotoy's avatar
Markzolotoy
Impactful Individual
10 years ago

When I choose XML as a data source it prompts me to seldect a file, but I want to get it from the webservice.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    10 years ago

    Hi Markzolotoy,

     

    You can see when you use web data source to get data, you just need to place the URL and extract records from the dataset. But in your scenario, the extracted records don't contain any fact data. So it's not a good option to use web data source if you want to get fact data.

     

    Best Regards,
    Qiuyun Yu

    • Markzolotoy's avatar
      Markzolotoy
      Impactful Individual
      10 years ago

      How come if I save my data into a file and then use that file for a data source then everything works fine? Search for my other message about json data. Same problem. Cannot get data when it's returned by a webservice, but the same json from the file is working fine.