Idea how to connect to an web database

[junko-ohara]

Hello, I have no idea if this is possible or not. I would like to have your thoughts.

There is a web database that we can search Patents internationally.

https://patentscope.wipo.int/search/en/search.jsf

Are we able to somehow connect to this database and get data (or somehow control and get the data we want), and analyse the data in PowerBI?

[quentin_vigne]

Hi @junko-ohara

Go to Obtain Data > Others > Web

And fill in the URL wanted 

- Quentin

[junko-ohara]

Hello @quentin_vigne, I tried that, but that only gets the UI. Which is no information at all. I would like to get data from the database.

[junko-ohara]

Another question, is there a way I can Get RSS feed to PowerBI?

[junko-ohara]

https://www.pauloldham.net/patent-databases/

I think I found an idea, find an API that is provided, and connect from PoweBI to that API.

.. Am I making sense here?

[quentin_vigne]

@junko-ohara

It kinda make sense as it looks complicated to get all the data from the website as you can't see the database.

- Quentin

[junko-ohara]

Hello, I have no idea if this is possible or not. I would like to have your thoughts.

There is a web database that we can search Patents internationally.

https://patentscope.wipo.int/search/en/search.jsf

Are we able to somehow connect to this database and get data (or somehow control and get the data we want), and analyse the data in PowerBI?