Launch Power BI (June 5, 2018 Version used for this post).
Click GetData and Choose SQL Server (you may choose a different source and the steps could be different).
Fill in details about Server and Database (this is better if you want to get directly to data that you need from a database).
Choose the Direct Query Option and click Advanced Options.
Click GetData and Choose SQL Server (you may choose a different source and the steps could be different).
The SQL Server database details page opens.
Fill in details about Server and Database (this is better if you want to get directly to data that you need from a database).
Choose the Direct Query Option and click Advanced Options.
Advanced options opens up for query insertion. Timeout is optional. This query is already filtered and should run fast. Insert the query as shown.
Click OK.
The data gets displayed. Load and it gets loaded as shown.
No comments:
Post a Comment