Forum Discussion
PBIX convert to table
Hi
Up to this week the report published here from pturley was working FANTASTICALLY!!! And we adapted to join a table of our specific office locations throughout the world and US.
https://github.com/paulturley/Power-BI-COVID-19-MVP
Now, all the data is blank...It seems that there is an issue where the data is not coming back in a convert to table that is in the transformation of a data source...
The source is
= Text.FromBinary(Web.Contents("https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_daily_reports"))
The applied convert to table gives this as a preview (which shows only this in Column1 of the created table):
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<link rel="dns-prefetch" href="https://github.githubassets.com">
<link rel="dns-prefetch" href="https://avatars0.githubusercontent.com">
<link rel="dns-prefetch" href="https://avatars1.githubusercontent.com">
<link rel="dns-prefetch" href="https://avatars2.githubusercontent.com">
<link rel="dns-prefetch" href="https://avatars3.githubusercontent.com">
<link rel="dns-prefetch" href="https://github-cloud.s3.amazonaws.com">
<link rel="dns-prefetch" href="https://user-images.githubusercontent.com/">
<link crossorigin="anonymous" media="all" integrity="sha512-aZYk5AYsRiFiFG04Si6FnQoHFwAugnodzKJXgafKqPWsrgrjoWRsapCn//vFuWqjSzr72ucZfPq8/ZbduuSeQg==" rel="stylesheet" href="https://github.githubassets.com/assets/frameworks-next-699624e4062c462162146d384a2e859d.css" />
<link crossorigin="anonymous" media="all" integrity="sha512-fbuShyqPldYTi4HwnoBrBL+UFa6nmRKUtancCPQKkVSzDJJAEVWUqdT9xR8UVMogwLDL8BVvUsEjtJOgthj3Iw==" rel="st...
Since this seems to be truncated, the next applied steps produce no data and hence the data source is blank.
Ideas??? Help?
Thanks!
1 Reply
- AnonymousNot applicable
Hi realik ,
You can refer the method in the below links by get the data from Web method(One thing to note is that the URL is obtained by clicking the "Raw" button on Github page) and check if the table can be converted normally:
Call custom functions file from Github or local file
How to import csv files from github in Power BI and avoid hard coded columns
Get URL
Get data from Web
Best Regards
Rena