Forum Discussion
Is it possible to connect to a .BAK file?
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
Community ChampionNot 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.
- Greg_Deckler
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