Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I recently went through the adventure bakery dataset where I downloaded .bak file but I am confused how to load it into PowerBI and apply some analysis on it.
Please let me know regarding it.
Solved! Go to Solution.
Hi @amansin19
A .bak file is usually a SQL Database backup file. So I'm guessing that what you have is a backup file of the adventure bakery database, which you need to restore to SQL server to access the data.
see Restore a Database Backup Using SSMS - SQL Server | Microsoft Docs
Once you've got the SQL data restored you can connect to it with Power BI to report upon it.
hope this helps
Stuart
Hi @amansin19
A .bak file is usually a SQL Database backup file. So I'm guessing that what you have is a backup file of the adventure bakery database, which you need to restore to SQL server to access the data.
see Restore a Database Backup Using SSMS - SQL Server | Microsoft Docs
Once you've got the SQL data restored you can connect to it with Power BI to report upon it.
hope this helps
Stuart
Hi @Burningsuit
Thanks for your comment, I will try this method as you mentioned.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
38 | |
26 | |
23 | |
19 | |
17 |
User | Count |
---|---|
49 | |
40 | |
24 | |
20 | |
20 |