Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
danieltodorov
Frequent Visitor

Importing content from HTM files from Sharepoint folder

Hi Guys,

 

I'm trying to set up a data load, in Power BI desktop (and later in the service, as a dataflow), which merges daily extracts, that are stored in a Sharepoint folder, in HTM format.

Each file has a table of the same structure embedded, and Power BI is able to recognize it as Table0. I can load it as data table and transform it, and using Local folder option (from my laptop), I can combine the Table0 from every file no problem.

However, when I try the exact same process, but with a sharepoint folder as a source, Power BI cannot read the content of the HTM files, instead, I get a Navigation to the webpage was canceled message:

sharepoint error.PNG

and at the same time, I get a popup window, this $value file being offered for download:

values.PNG

The $value file actually contans the htm file content, which PBI would need to analyze.

 

Can you help me, what to set or check, to make it actually read the htm content, instead of downloading it?

 

ps.: I have read permission on Sharepoint for the base URL and the files themselves too.

7 REPLIES 7
deepikaajith
Frequent Visitor

what is the solution to this problem. I am also facing the same issue
Stachu
Community Champion
Community Champion

can you share the M code that PowerBi generated for this query?



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Coming back to the issue today, I got  different error message. Now I cant even select the table from the htm file to be mereged, because I get this message on the Comibne Files screen:

sharepoint error2.png

I started it from blank pbix, so I have no other queries my parameter can interefere with. Since I cannot hit OK, I doesnt generate the m query which would be worth sharing. 

So I Cancelled and extracted the Content columns's Binary data from one file, there I get to the same error I originally posted. The M query looks like this:

 

let
Source = SharePoint.Files("https://company.sharepoint.com/sites/Move/", [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Name], "VBFA_")),
#"2020-04-24T08_55_56+00_00 VBFA_ Display of Entries Found htm_https://company sharepoint com/sites/Move/Shared Documents/DATA/Blank subject emails (mostly SAP data)/" = #"Filtered Rows"{[Name="2020-04-24T08_55_56+00_00 VBFA_ Display of Entries Found.htm",#"Folder Path"="https://company.sharepoint.com/sites/Move/Shared Documents/DATA/Blank subject emails (mostly SAP data)/"]}[Content],
#"Imported HTML" = Web.Page(#"2020-04-24T08_55_56+00_00 VBFA_ Display of Entries Found htm_https://company sharepoint com/sites/Move/Shared Documents/DATA/Blank subject emails (mostly SAP data)/"),
Data = #"Imported HTML"{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data,{{"Column1", type text}, {"Column2", type text}})
in
#"Changed Type"

 

So this query gives me the original "Navigation to the webpage was canceled" error. I did one modification before posting, changed the company's actual name to company.

Hi @danieltodorov @deepikaajith ,

 

I came across the same issue, so when you locate your file in SharePoint, add a custom column to read the Text first, before Web.Page, if you have mutiple tables constructed in the HTM file, you may need to add a custom column to count the columns so you can find those tables you want. Let me know if you need any further help.

 
Source = SharePoint.Files("https://company.sharepoint.com/sites/Move/", [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Name], "VBFA_")),
#"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each Text.FromBinary([Content])),
Custom1 = Web.Page( #"Added Custom"[Custom]{0})
in
Custom1

Hi,

Can you show us with some example so we can follow the sma esteps in our file?

Hi @deepikaajith 

 

How about you posting your M code and screenshot of your Power Query Editor (hide anything sensitive)? I can help from there.

The solution proposed by Vera_33 worked as a charm for me! Thank you very much!

Just to clarify, I did not even need to customise the code she proposed, so I just copy/pasted the following in the editor:

#"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each Text.FromBinary([Content])),
    Custom1 = Web.Page( #"Added Custom"[Custom]{0}),
    Data = Custom1{0}[Data],

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors