cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zirochka Frequent Visitor
Frequent Visitor

automatically upload data to power bi

Hi everyone,

I have a task at my job (hare is brief description):

we have an app in which user can request some data from DB with various filters. Then an app creates .csv file (always with the same structure, but always with different content). For example, we always have only this fields:

"Name" "Soname" "Age" "Sex" "Address" "Contact info" "Hobbies"

and depending on filters which where chosen we fill the file (if user chose 2017 year, we fill the file with data only for 2017 year; if user chose name "Alex", we fill the file with data only for name Alex; etc). Then user click on "Show in Excel" button and data from .csv file displays at graphs in excel. We use VBScript to do it automatically.

 

And now we want to use a Power BI for data visualization instead of excel.

Now we are using Selenium WebDriver C# to do this but it's not really a good solution (because we do imitation of user's actions on a web site - https://app.powerbi.com):

  1. log in on the https://app.powerbi.com
  2. upload data from .csv file
  3. click on upoaded dataset
  4. user now can visualize this data a way he wants (we don't need to build graphs (users themselves will build graphs), just upload the data)

I know that PBIDesktop is not for us because when you launch PBIDesktop, you may:

  1. launch PBIDesktop
  2. open .pbix file (it is a report which is already done)

 

To conclude:

  1. each time we have .csv file with different content
  2. we need to upload it on Power BI somehow (now we are using Selenium WebDriver for uploading on https://app.powerbi.com)
  3. users build their own amazing visualizations

 

I would like to know if there are another solutions for my task? If you have any questions about the details of what we need, please, ask.

I will appreciate any help.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator Eric_Zhang
Moderator

Re: automatically upload data to power bi


@Zirochka wrote:

Hi everyone,

I have a task at my job (hare is brief description):

we have an app in which user can request some data from DB with various filters. Then an app creates .csv file (always with the same structure, but always with different content). For example, we always have only this fields:

"Name" "Soname" "Age" "Sex" "Address" "Contact info" "Hobbies"

and depending on filters which where chosen we fill the file (if user chose 2017 year, we fill the file with data only for 2017 year; if user chose name "Alex", we fill the file with data only for name Alex; etc). Then user click on "Show in Excel" button and data from .csv file displays at graphs in excel. We use VBScript to do it automatically.

 

And now we want to use a Power BI for data visualization instead of excel.

Now we are using Selenium WebDriver C# to do this but it's not really a good solution (because we do imitation of user's actions on a web site - https://app.powerbi.com):

  1. log in on the https://app.powerbi.com
  2. upload data from .csv file
  3. click on upoaded dataset
  4. user now can visualize this data a way he wants (we don't need to build graphs (users themselves will build graphs), just upload the data)

I know that PBIDesktop is not for us because when you launch PBIDesktop, you may:

  1. launch PBIDesktop
  2. open .pbix file (it is a report which is already done)

 

To conclude:

  1. each time we have .csv file with different content
  2. we need to upload it on Power BI somehow (now we are using Selenium WebDriver for uploading on https://app.powerbi.com)
  3. users build their own amazing visualizations

 

I would like to know if there are another solutions for my task? If you have any questions about the details of what we need, please, ask.

I will appreciate any help.

 

 


@Zirochka

There's no official tool but Powerbi.com provides an API to push data. This would need some programing skill and it would allow to push data from your database directly as well, instead of from a csv file.

 

By the way,I think Power BI desktop may be available as well. You can connect to the csv file or even directly to database in Power BI Desktop. After published, you'll get a dataset in Powerbi.com and you can schedule refresh for the dataset by using the Power BI  gateway.

View solution in original post

5 REPLIES 5
Moderator Eric_Zhang
Moderator

Re: automatically upload data to power bi


@Zirochka wrote:

Hi everyone,

I have a task at my job (hare is brief description):

we have an app in which user can request some data from DB with various filters. Then an app creates .csv file (always with the same structure, but always with different content). For example, we always have only this fields:

"Name" "Soname" "Age" "Sex" "Address" "Contact info" "Hobbies"

and depending on filters which where chosen we fill the file (if user chose 2017 year, we fill the file with data only for 2017 year; if user chose name "Alex", we fill the file with data only for name Alex; etc). Then user click on "Show in Excel" button and data from .csv file displays at graphs in excel. We use VBScript to do it automatically.

 

And now we want to use a Power BI for data visualization instead of excel.

Now we are using Selenium WebDriver C# to do this but it's not really a good solution (because we do imitation of user's actions on a web site - https://app.powerbi.com):

  1. log in on the https://app.powerbi.com
  2. upload data from .csv file
  3. click on upoaded dataset
  4. user now can visualize this data a way he wants (we don't need to build graphs (users themselves will build graphs), just upload the data)

I know that PBIDesktop is not for us because when you launch PBIDesktop, you may:

  1. launch PBIDesktop
  2. open .pbix file (it is a report which is already done)

 

To conclude:

  1. each time we have .csv file with different content
  2. we need to upload it on Power BI somehow (now we are using Selenium WebDriver for uploading on https://app.powerbi.com)
  3. users build their own amazing visualizations

 

I would like to know if there are another solutions for my task? If you have any questions about the details of what we need, please, ask.

I will appreciate any help.

 

 


@Zirochka

There's no official tool but Powerbi.com provides an API to push data. This would need some programing skill and it would allow to push data from your database directly as well, instead of from a csv file.

 

By the way,I think Power BI desktop may be available as well. You can connect to the csv file or even directly to database in Power BI Desktop. After published, you'll get a dataset in Powerbi.com and you can schedule refresh for the dataset by using the Power BI  gateway.

View solution in original post

Zirochka Frequent Visitor
Frequent Visitor

Re: automatically upload data to power bi

"There's no official tool but Powerbi.com provides an API to push data."

so, you say that with this API I can push data to https://app.powerbi.com and this will be equivalent to how I would do it manually? Result will be the same?

sandralynn Frequent Visitor
Frequent Visitor

Re: automatically upload data to power bi

I could automate that OAuth interaction with Selenium WebDriver.

 

A dataset is automatically created in Power BI when you use Get Data to connect to and upload data from a content pack, file, or you connect to a live data source. In Power BI Desktop and Excel 2016, you can also publish your file right to the Power BI service, which is just like using Get Data.

 

 

sandralynn Frequent Visitor
Frequent Visitor

Re: automatically upload data to power bi

I could automate that OAuth interaction with Selenium WebDriver.

Highlighted
kimjohn Frequent Visitor
Frequent Visitor

Re: automatically upload data to power bi

This information was very useful to me!!

Regards,

  Selenium Training in Chennai|Selenium Course in Chennai

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 55 members 1,216 guests
Please welcome our newest community members: