Web table as a data source bug

[D3K]

Hi everyone!

Faced to the next bug, when getting data from the Web table.

I'm using 2 PCs: my own laptop for simple actions in desktop Power BI version (measures, graphs etc.) and VPS mighty server machine for complicated queries. 

In one report I have as a datasource a Web-table with currencies exchange rate. And I have the next issue: when I open my report on my own laptop (Windows 10) this web page with needed table in Power BI looks like:

And when I open it on the VPS (Windows Server Standard 2019) it looks like:

As you can see the same table on the same page has different "addresses": Table 9 and Table 5.

And it causes different chain of the further query code. And if I'm working on the VPS and loading it from my laptop PBI Service gives me back an error, that it can't find needed columns. And I can understand it: in query it is in the Table 5 (because I need to refresh queries on the VPS machine), but the PBI Service is looking for it in the Table 9. 

Here is the link with currencies archive https://finance.tut.by/arhiv/?currency=USD&from=01-01-2019&to=11-12-2019

I can't refresh PBIX file on my own laptop, because it has not enough memory.

What am I doing wrong? Maybe it depends on browsers using on on different machines or something else?

Any help will be highly appreciated. Thanks!

[mwegener · Accepted solution]

Hi @D3K ,

this page seems to be very dynamic. I get 15 tables.

You may have to optimize the "Extracted Table from Html" M-Code.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi @D3K ,

Is the system language different?
This will be sent in the HTTP header.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[D3K]

@mwegener  thanks for your attention and the answer

Languages in the systems were different and I've changed the language of the Windows Server on the VPS, but nothing have changed - PBI Navigators still see different number of tables in the same page

[v-juanli-msft]

Hi @D3K 

Do you use the lastest version of Power BI Desktop?

When you use other tool to get data from web on Windows Server, do all tables show?

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[D3K]

Hi Maggie @v-juanli-msft 

Yes it is the latest version on both systems 2.75.5649.961 64-bit (November 2019)

---

When you use other tool to get data from web on Windows Server, do all tables show?

---

What tools can I try except Web-connector to check it?

Thank you

[mwegener · Accepted solution]

Hi @D3K ,

this page seems to be very dynamic. I get 15 tables.

You may have to optimize the "Extracted Table from Html" M-Code.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[D3K · Accepted solution]

Thanks @mwegener  You put an idea into my head with 

---

You may have to optimize the "Extracted Table from Html" M-Code.

---

And I've found a pretty easy way to solve such problems with dynamic pages.

Step 1. Grab any table from a page by couple of clicks

https://eagereyes.org/data/scrape-tables-using-google-docs

Step 2.  Make gotten Google Spreadsheet from step 1 as a data source

https://community.powerbi.com/t5/Power-Query/How-to-connect-google-sheet-to-Power-BI/td-p/14587

*check the Solution post

Thanks to all very much!