Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
10 years ago
Solved

Connect to on-premise data

I have created a report Power BI Desktop that gets data from on-premise SQL Server. I have published the report that I can see on https://app.powerbi.com. I have also installed personal gateway and have gone thru its Wizard. When adding the report to a dashboard and selecting some fields I am gettiing:

 

Couldn't load the data for this visual
 
Your data gateway (Power BI – personal) is offline, but a data gateway is available.
Please try again later or contact support. If you contact support, please provide these details.
 
I think it worked at some point before or I am jsut overwhelmed with all this stuff. Please help me to figure it out.
 
Thanks
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi Markzolotoy,

     

    Based on my understanding, it seems that you get data from the SQL Server database use Import mode instead of DirectQuery mode, right?

     

    In your scenario, you can configure dataset use both personal gateway and on-premises data gateway to enable connection to SQL Server data source. From the error message, we can see that the personal gateway is offline currently while this dataset is using this personal gateway, so the connection is failed and data can't be retrieved.

     

    You can open the Power BI Service, then click Settings->Datasets, find the dataset used by this report, then expand Gateway Connection tab, check if personal gateway is running.

     

     

     

    If not, you can start the personal gateway follow this article: Power BI Gateway - Personal. Or you can configure a data source connect to the SQL Server database under on-premises data gateway, then set this dataset to use this on-premises data gateway connection, see:

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    10 years ago

    Hi Markzolotoy,

     

    Based on my understanding, it seems that you get data from the SQL Server database use Import mode instead of DirectQuery mode, right?

     

    In your scenario, you can configure dataset use both personal gateway and on-premises data gateway to enable connection to SQL Server data source. From the error message, we can see that the personal gateway is offline currently while this dataset is using this personal gateway, so the connection is failed and data can't be retrieved.

     

    You can open the Power BI Service, then click Settings->Datasets, find the dataset used by this report, then expand Gateway Connection tab, check if personal gateway is running.

     

     

     

    If not, you can start the personal gateway follow this article: Power BI Gateway - Personal. Or you can configure a data source connect to the SQL Server database under on-premises data gateway, then set this dataset to use this on-premises data gateway connection, see:

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu