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
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
If you want to give a SQL, you can give under advance option
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 .
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.
