Table of Contents
...
- An online report editor to create reports / dashboards
- Note: Can load up single tables and create reports - but not link tables together nor do data cleansing
- Online Consumption of reports
- Reports once published are accessable by users
Where
...
Power BI can get data
One power BI model can have data from lots of places at the same time
Power Bi can accept data from many sources into a dataset as you can see here...
...
If you have setup a SQL Azure database - then you can connect from the desktop or from the online version
How to populate the Azure database from the system
Publishing the data to the Azure Database is from the Financial Period
| Note |
|---|
If you connect using the onine version and your data looks funny - it might be because the database does not have "Primary Keys" setup to link the tables together. If this is the case you will have to connect via Power BI desktop to define the relationships and then publish to PowerBI online |
...
| 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
...
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/
...