Forum Discussion
How to import SQL files to Power BI
Hi Trooz
Ifthis 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
Hi Trooz
Ifthis 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
v-diye-msft Thanks a lot
Hi, can you explain what did you do? I have the same two sql files.
First of all you need to create databases from these two sql files through MS SQL server studio.
Open MS SQL server studio on your computer and you'll get a prompt to enter the Server Name. To find the server name, open SQL Server Configuration Manager by clicking on Start on your computer. In SQL Server Configuration Manager, click on SQL Server Services on the left, then on the right you should see SQL Server (either a year for version or SQL Express), double click on it, go to the Services tab, and you'll see the server name under Host field. (Remember, if you are using SQL Express version, you'll need to put \SQLEXPRESS after the host name as the server name.
Once this is done, and you are able to login to MS SQL Server Studio, double click on those two files and run the queries, the databases will be created.
Once this is done as well, use the same server name in Power BI.
