Table of Contents
...
Power Bi can accept data from many sources into a dataset as you can see here...
Example - Connecting to SQL Azure Database
If you have setup a SQL Azure database - then you can connect from the desktop or from the online version
| 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 |
Connecting from Power BI Desktop
Exporting from Lists in the system (CSV files)
...
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/
...