Forum Discussion

Juc's avatar
Juc
Regular Visitor
8 years ago

Power BI Desktop and Live SQL connection question

Hello All,   Fairly new to Power BI and not sure if I am posting in the right place (Apologies in advance)   I created a report on Power BI desktop that imports data from a SQL server database an...
GilbertQ's avatar
GilbertQ
Super User
8 years ago
Hi there.

You said you imported the data into Power BI. So the data will not be live.

If you want it to be live when connecting to SQL Server you will select Connect Live. And then select your tables.

You will then have to install and configure the On-Premise Gateway
Juc's avatar
Juc
Regular Visitor
8 years ago

Thanks GilbertQ!

 

Sorry, to clarify on Power BI Desktop I used Get Data > SQL Server, built the report and then used Get Data > Local File on Power BI Live. 

 

So all I need to do now is configure the On-Premise Gateway?

 

I get this error when refreshing the dashboard on Live.

 

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago

    Hi Juc

     

    If you look at the error it is asking for credentials for all the data sources in the Gateway. So if you can have a look and ensure that they are correctly set.