Table of Contents
...
If your system has a BI Download configured - these files save as CSV with the "|" character as the delimiter
| Note |
|---|
This Downloaded data will have to be refreshed by you manually into Power Bi The date sent to your datawarehouse will be obe based on the date range you define.It will over-write similar data if it already exists. |
Connection to a SQL Database (in Azure)
If you have large volumes of data and want regular automatic updates to it - an SQL Database is the ideal method.
The ideal place for this database is in SQL Azure - it is cheap and in the same place as Power Bi Online so data does not travel across your network for designing and refreshing the report data.
- For those that like excel it can also connect to Azure... https://blogs.technet.microsoft.com/office_online_support_blog/2015/10/29/excel-online-refreshing-data-to-a-sql-azure-database/ and https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/
...
If you connect to a database that is not in the same place (ie on your site) then every time you refresh the data in PowerBi online (it only has a complete data refresh - not an add updates) - there will be significant traffic on your network.
Data Cleansing
Once you have the data in Power Bi
...