Forum Discussion
Import Excel Workbook and Refresh It
Hello everyone! In an Excel sheet, I have a connection where a query is pulling in data from our SQL Server. When I loaded the data into the Excel sheet, I added it to the Data Model. I saved...
How would PowerBI tell the excel file to connect to the SQL server and exec the command and pull the data back...
Why are you not just putting the SQL directly into PowerBI. If you can run it from Excel, you can run it from PowerBI I would have thought. Much better performance, and much better governance and easier to maintain, easier to track and fix problems.
Why are you not just putting the SQL directly into PowerBI. If you can run it from Excel, you can run it from PowerBI I would have thought. Much better performance, and much better governance and easier to maintain, easier to track and fix problems.
Yes, if you just want to show the result of a SQL query you would probably be better off to just build a paginated report using report builder. If the query is very expensive and you only want to run it once a day you could setup a caching policy. Paginated reports can also export to Excel if that is where your users want to see the data.