...
Power Bi can accept data from many sources into a dataset as you can see here...
- all into a single data set
- Manage multiple data sets
Exporting from Lists in the system (CSV files)
Extracts from any list in the system - choose a date range etc if required.
| Note |
|---|
This data will have to be refreshed by you manually into Power Bi |
BI Extracts (CSV Files)
If your system has a BI Download configured - these files save as CSV with the "|" character as the delimiter
...
...
| Note |
|---|
This data will have to be refreshed by you manually into Power Bi |
Connection to a SQL Database
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.
| Note |
|---|
We will need to set this up for you and the regular refreshes of data to it from our system. |
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.
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...