Forum Discussion
Website Power query connection
Hello everyone, I have a challenges where I want to import data from a website using Power Query for daily refreshing (data refreshes every day at 1pm). Although, when I try to connect to it, the...
I can see the suggested table Tabular data (using Microsoft 365 btw.), but the problem is that when I load it, it appears as an empty table. And if you visit the actual website, it is not empty at all, but filled with 24-hour data, and that is the actual data I am trying to import to Excel spreadsheet.
Afraid Power Query won't help. Body of the table is not in HTML directly, thus nothing to parse. If to check html body is generated by some function. That's all what Power Query see:
<h2> Tabular data </h2>
<table>
<thead><tr>
<th scope="col" class="first"> Hour </th>
<th scope="col"> Volume </th>
<th scope="col" class="last"> Price </th>
</tr></thead>
<tbody id="results-table-da-tbody"></tbody>
</table>
<script>document.addEventListener('DOMContentLoaded',function(event) {
if(!BSPCharts.table.da.INITIALIZED) {
BSPCharts.table.da.hDate=document.getElementById('auction-chart-date');
BSPCharts.table.da.hTableBody=document.getElementById('results-table-da-tbody');
setTimeout(function(){BSPCharts.table.da.init()},1500)
}
}
)</script>