The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Can a .Bak file be connected to in Power BI?
Solved! Go to Solution.
Assuming this is SQL Server .BAK files, just restore the .bak files to any SQL Server and use that. You could also take it a step further and just use the SQL Server as an intermediary and create bacpac files of them so that you can run the SQL Server using something low cost like Azure SQL DB.
http://stackoverflow.com/questions/12057661/converting-sql-bak-to-sql-backpac-format
Not to my knowledge, no.
What would be needed to utilise the .Bak files in Power Bi?
We don't have access to the real tables...just .bak files fro mthe previous night.
Assuming this is SQL Server .BAK files, just restore the .bak files to any SQL Server and use that. You could also take it a step further and just use the SQL Server as an intermediary and create bacpac files of them so that you can run the SQL Server using something low cost like Azure SQL DB.
http://stackoverflow.com/questions/12057661/converting-sql-bak-to-sql-backpac-format