How to import SQL files to Power BI

[Trooz]

Dear All,

I would like to ask you how can I import two SQL files that I've downloaded to Power BI as I have no experience with SQL servers. I've only downloaded an application called "Microsoft SQL server Management" but I don't know how to go further?

Thanks in advance 🙂

[amitchandak]

@Trooz , It not clear you want to connect to SQL server of having sql statement which you want to run

Refer

https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-sql-server-data-in-po...

If you want to give a SQL, you can give under advance option

[Trooz]

@amitchandak Hi Amit thank you for your reply and I'm sorry for not being clear enough.

I've checked the links you provided but unfortunately I didn't understand properly how can I fix the issue.

Simply I have those two SQL files (That include the table which I should work on)

 

When I click "SQL server" on Power BI

I'm asked to enter the SQL server which I don't know ... As you saw I have the files on my local device so (I want to create a local server to upload these files then get connected to this server and use the files) this is what I understood , I don't know if this works as I explained or I should follow another way to import these files on Power BI .

[v-diye-msft · Accepted solution]

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

[Trooz]

@v-diye-msft  Thanks a lot

[Blackee]

Hi, can you explain what did you do? I have the same two sql files.

[calebishere]

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.