PowerBI having issues getting data from htm file on sharepoint with 4 tables in. It works fine when the htm file is stored in local folder, then powerBI can read the 4 tables. The htm file on sharepoint looks fine with 4 tables in. I search for data as "get data from sharepoint folder" and I can find the file name as binary data, but powerBI cannot read table 1-4. It states that the file is empty, but it is not.
I have tried as web and the other sharepoint folders as well. In addition several people from my work have tried without any luck as pro powerBI guys.