Enter your SQL Azure Database name, and then click OK.
Select the Use a specific user name and password option, and then enter the User name and Password. Select the correct database under Select the database dropdown, and then click Test Connection to make sure that the connection is successful.
ข้อสำคัญ
Select the Allow saving password check box.
Select the table that you want to use, and then click Next.
On the Save Data Connection File and Finish window, click Finish.
Select Pivot Table Report (in this example).
ข้อสำคัญ
For this report to refresh in Excel only, you must select the Add this data to the Data Model check box.
If you are prompted to re-enter the password, re-enter it.
Make sure that the password is embedded in the connection string. To do this, in the Excel client, select Data > Connections > Properties > Definition tab. Make sure that there is a check box next to Save Password and also make sure that the password is indeed embedded in the connection string (it should say Password=<YourPassword> at the end of the connection string), and then click OK.
If you did have to select the Save password check box, the connection string will change. Therefore, you will be informed that the connection string is now different from the .odc file. The warning is ok, and you just click Yes.
Now, you see that a Data Model is added to the workbook. This is important to a successful refresh in Excel Online.
Upload this workbook to Excel Online, and then test refreshing in the browser through Data > Refresh All Connections.
โมดูลนี้จะเกี่ยวกับวิธีการที่เป็นไปได้ที่บุคคลสามารถใช้ Excel และ Power BI ร่วมกันได้ Power BI เป็นเครื่องมือที่ดีในการบอกดูผ่านภาพ ในบางครั้ง การใช้ Excel เพื่อการวิเคราะห์ Excel สามารถเชื่อมต่อกับชุดข้อมูล Power BI ได้ ซึ่งช่วยให้คุณสามารถวิเคราะห์ข้อมูลได้โดยใช้ PivotTables
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.