automatically upload data to power bi

[Zirochka]

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.

[sandralynn]

I could automate that OAuth interaction with Selenium WebDriver.

[sandralynn]

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.

[Eric_Zhang · Accepted solution]

---

@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.

[kimjohn]

This information was very useful to me!!

Regards,

  Selenium Training in Chennai|Selenium Course in Chennai

[Zirochka]

"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?