Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Importing HTM files in Sharepoint Folder

Hi Everyone,

I've been trying to import the data in HTM files that are kept in sharepoint folder but cannot read the files.

 

I tried the method below but my file appears empty. (Excels working just fine, problem is specific to HTM files.) 

 

https://community.powerbi.com/t5/Desktop/Connecting-to-SharePoint-Folder-error/m-p/1050215

 

 

Also I tried using Web.Page(Web.Contents...) but this time I'm receiving "the credentials provided are invalid error" even though I'm having no issue with using  Excel.Workbook(Web.Contents...) for the excel files in the same location. 

 

 

Any idea about what i'm doing wrong, or do you know any other way to read HTM files that are kept in sharepoint folders?

 

many thanks in advance.

 

 

 

 

 

 

 

Need Help
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , You have taken url using the copy link of file? and were you able to give user credentials ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak

       

      1. Yes, I used the copy link of file and deleted unnecessary parts. (The way I do for my excel files.)

      This file is located in the same folder with my excel files which I have no issue with reading. 

       

      2. Yes, I gave user credentials for reading excels in other queries in the same project, it worked just fine as usual, but when it comes to reading this file im receiving invalid credentials error.

       

      many thanks 

       

       

  • aggisss's avatar
    aggisss
    Frequent Visitor
    3 years ago

    I have same issue.
    Any idea how to fix it?