Forum Discussion
Connect to SQL database - using script
Hi guys
I am very new to power Pi , and have years of experience with qlik .
in qlikview I am using Script to
connect to SQL SERVER
and SELECT functio to load data from the tables .
is it possible to do it by script also ?
if yes how can I do it
thanks
gidon
Yes. There are not many differences between Free & Pro Version. Everyting is same, Except limitations in uploading and sharing dashboards in PRO version have more options than Free PowerBI Service account.
4 Replies
Yes, You can do that in PowerBI as well.
Go to the Get Data Tab, Select SQL Server, Specify the Server & Database Name
To write custom SQL Script, Select Advanced Options, Create your Script and You would able to work with the data.
PowerBI offers flexibility in terms of connection as well. You can use either Import Mode or Direct Query mode. Just to clarify, There are some limitations in Direct Query mode.
Hope this will help you understand PowerBI features & Capabilities.
Hello Bhavesh
Thanks for your prompt reponse .
as a qlik developer i am used to write script edit them .
i asume the way you described it is the only way to connect .
it works the same way also with the enterpirse version ?
thanks
gidon
Yes. There are not many differences between Free & Pro Version. Everyting is same, Except limitations in uploading and sharing dashboards in PRO version have more options than Free PowerBI Service account.
