cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohanLudvig Frequent Visitor
Frequent Visitor

Error: We couldn't refresh because your data gateway (Power BI – personal) is offline

We get this error on several reports, despite having no personal gateways configured on our subscription.

But with all but two reports/datasets we can change which gateway connection to use - as we do have an active On Premise data gateway. 

On the two last reports however, the option to use the configured data gateway is greyed out.

On Report 1 all sources used exists in the On premise gateway. We have verified that they are spelled the same way and use same case in both report and gateway.

Report 2 has 1 internal source - verified spelled same way and using same case as on the data gateway.

The other source is an Azure SQL DB - which as far as I can see in the documentation should never hit the gateway.

 

Both pc's that has been used to create these reports had data managment gateway installed, but not configured - as the corporate firewall and proxy blocks this. As the screenshot shows, there is no registred computer for the gateway.

gateway error.png

Does anyone have any suggestions on how to proceed?

I was wondering if there might be some way to view the code in the pbix file and scan for gateway references or double check the connection strings - but haven't found any so far.

 

 

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Error: We couldn't refresh because your data gateway (Power BI – personal) is offline

Hi @JohanLudvig,

Based on your description, you are not able to use on-premises gateway to refresh two datasets as the option is greyed out.

For Report 1, could you please post a screenshot of your data sources in Power BI Desktop and post screenshots of your data sources under gateway ? You can go to File -> Options and settings ->Data source settings to check data sources for Power BI Desktop.

For Report 2, you combine Azure SQL database and other data sources, right? If so, please also add the Azure SQL database data source under on-premises gateway,  they check if you can use on-premises gateway to refresh the dataset.

In addition, have you checked if personal gateway is installed in the computer that the above error message mentions?

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JohanLudvig Frequent Visitor
Frequent Visitor

Re: Error: We couldn't refresh because your data gateway (Power BI – personal) is offline

I'm not allowed to add the Azure SQL DB to my on-premise gateway @v-yuezhe-msft

I'm getting the error:

 "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) DM_ErrorDetailNameCode_UnderlyingHResult: -2146232060 DM_ErrorDetailNameCode_UnderlyingNativeErrorCode: 53"

 

And yes, the firewall settings are set to allow access to Azure services.

 

As I mention, there is no personal gateway installed on the computer. And the error message shows "(disconnected, running on)"

so it doesn't mention any computer in the error message.

Moderator v-yuezhe-msft
Moderator

Re: Error: We couldn't refresh because your data gateway (Power BI – personal) is offline

Hi @JohanLudvig,

I am able to add Azure SQL data source under on-premises gateway.
1.PNG

In your scenario, except “allow access to Azure services” setting, please ensure that and you have set up a firewall rule to allow Power BI gateway to make a connection to Azure SQL.

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors