topic Re: Connect to SQL database - using script in Developer

Connect to SQL database - using script

gidon — Fri, 14 Oct 2016 05:20:48 GMT

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

Re: Connect to SQL database - using script

BhaveshPatel — Fri, 14 Oct 2016 08:16:09 GMT

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.

Re: Connect to SQL database - using script

gidon — Fri, 14 Oct 2016 11:15:43 GMT

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

Re: Connect to SQL database - using script

BhaveshPatel — Fri, 14 Oct 2016 11:20:02 GMT

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.

Re: Connect to SQL database - using script

gidon — Sun, 23 Oct 2016 20:04:15 GMT

can you help me with this post - i did not get an asnwer - thanks gidon

Hello

i have a pbix model which is steady base.pibx .

i want to start new model ( power bi doc ) data.pbix

i want to strat with the base model , so i have all my base tables ready .

in qlik we used binary connect

thanks

gidon