Table of Contents
...
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/
...
- Connection string
- Username
- Password
- Select a Database
| Include Page | ||||
|---|---|---|---|---|
|
Then Select the Tables Required
Select the tables to view
You can filter the tables prior to import to reduce the data
Use preview and filter above
Then import the data
Then link the tables with Relationships
Review the relationships
Then hide columns a user would not require
How hidden columns look
Related articles
...