cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

how to connect to github and import csv file into power bi

Hello,

 

I would like to import a csv file (iris.csv) located to this link:  https://gist.github.com/netj/8836201

 

using the github (beta)

 

I have tried 

owner: netj

repository name:8836201

 

but the data never showed-up

 

Does someone know the steps to do from get data, github (beta)

Thanks in advance for your help

 

15 REPLIES 15

Try to use  raw.githubusercontent.com  url mode 

 

example

https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_ti...    in  text/csv  get data.

 

 

 

Frequent Visitor

I successfully connected to the data source via web connector which was advised in this thread. However, when uploading the PBI file to the PBI.COM and set a scheduled refresh, it always failed, saying :

 

"We're sorry, an error occurred during evaluation.;The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified The system cannot find the file specified. The exception was raised by the IDbCommand interface."

 

I tried add a credential (login credential to Github) and some others, but the error lingers on.

 

Does anyone know how to fix the issue??

 

 

Thanks,

looking for the same thing, were you able to connect and use the data somehow?

 

for example

https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_time_series/...

Hi @nalhemyari / @Bryan75  any success with connection to COVID-19 data?

Anonymous
Not applicable

Hello,

 

I have received so much help from the community .  Now, I am able to help at least for this question.

 

First point.  If you would like to test the github connector, I will refer you to that page : https://docs.microsoft.com/en-us/power-bi/service-connect-to-github   , which explain in details how to connect a githubsite.  There is also a Pbix file that you can download.

 

In this example, it refer to the following github site: https://github.com/MicrosoftDocs/powerbi-docs

It will be a good thing to visit that site, just to see how it looks like.   So, in tha above URL, MicrosoftDocs is the owner and powerbi-docs, the repository.

 

If you are interesed by the covid-19 site, there is a video on youtube which explain how to get the data by using a web connector not a github connector.  Here's the url for the video.  https://www.youtube.com/watch?v=qWHIJikCw-8

 

The author of this video explain the various steps to get this url 

https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_ti...

 

Then you go in Power Bi , getdata, select a web connector, and copy and paste the url https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_ti... and you will get the data

 

Good luck!

 

 

@Anonymous   Thank you a lot! I hope that one day I will be able to pay my debt to community as well 😉

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors