Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dilaraa12
Regular Visitor

Automatic refresh OData

Hi,

I used OData in Power BI. I want to set up automatic refresh but I'm getting an error. I am pulling data into Power BI with the gateway on another employee's computer, but I cannot see this gateway in online Power BI. As in the image below:

dilaraa12_0-1695209487699.png


Also, I cannot update in online Power BI and I get the following error:

dilaraa12_1-1695209879390.png

 


When I enter the connection settings in the 'Manage Connection and Dataset' area, I select basic as the authentication method. I enter the username and password I have to access the data. The save button is active, but nothing happens when I click it. (Extra information: Gateway Cluster Name: personal mode). Where am I making a mistake?


Also, as far as I know, in this scenario the computer must be on during the automatic renewal process. Is there a way to automatically refresh data that does not require the computer to be turned on?

1 ACCEPTED SOLUTION
vs_7
Responsive Resident
Responsive Resident

HI @dilaraa12 
check out the below steps

It seems like you're encountering a few issues with setting up automatic refresh for an OData data source in Power BI.

  1. Gateway Visibility Issue:

    • The fact that you can't see the gateway in Power BI Service (online) suggests there might be an issue with the configuration of the gateway or the permissions associated with it.
    • Ensure that the gateway is installed and running on the computer where you are connecting to the OData data source. Additionally, make sure that the employee's computer running the gateway is online and connected to the Power BI service.
    • Check that the gateway is configured correctly and that the data source (OData) is added to the gateway configuration.
  2. Error When Updating in Power BI Service:

    • The error message you're encountering when trying to update the dataset in Power BI Service could be due to various reasons. It's essential to diagnose the specific error message to pinpoint the issue.
    • First, check if the dataset has been published successfully and if there are any errors during the publishing process. You can review the error details in the Power BI Desktop or Power BI Service.
  3. Gateway Configuration:

    • Ensure that the authentication method and credentials used for the OData connection in Power BI Desktop match the credentials required by the OData service. Double-check that the username and password are correct.
  4. Gateway Mode:

    • "Gateway Cluster Name: personal mode" indicates that you are using the Personal Gateway mode. In this mode, the computer running the gateway must be turned on and connected to the internet for automatic refresh to work. If the computer is off or not connected, automatic refresh will fail.
  5. Scheduled Refresh without Gateway:

    • If you want to enable scheduled refresh without relying on a computer being turned on, you should consider using the Power BI On-premises Data Gateway (Standard Mode). In Standard Mode, you can configure a scheduled refresh even when the computer is not online. This is suitable for scenarios where the computer may not always be available.
  6. Troubleshooting the Save Button Issue:

    • If the "Save" button is not working when configuring the OData connection, it could be a technical issue with your Power BI Desktop installation. Try restarting Power BI Desktop or repairing/reinstalling it if necessary.
  7. Permissions and Roles:

    • Ensure that the user account you are using to access the data source has the necessary permissions and roles assigned within the OData service.

View solution in original post

1 REPLY 1
vs_7
Responsive Resident
Responsive Resident

HI @dilaraa12 
check out the below steps

It seems like you're encountering a few issues with setting up automatic refresh for an OData data source in Power BI.

  1. Gateway Visibility Issue:

    • The fact that you can't see the gateway in Power BI Service (online) suggests there might be an issue with the configuration of the gateway or the permissions associated with it.
    • Ensure that the gateway is installed and running on the computer where you are connecting to the OData data source. Additionally, make sure that the employee's computer running the gateway is online and connected to the Power BI service.
    • Check that the gateway is configured correctly and that the data source (OData) is added to the gateway configuration.
  2. Error When Updating in Power BI Service:

    • The error message you're encountering when trying to update the dataset in Power BI Service could be due to various reasons. It's essential to diagnose the specific error message to pinpoint the issue.
    • First, check if the dataset has been published successfully and if there are any errors during the publishing process. You can review the error details in the Power BI Desktop or Power BI Service.
  3. Gateway Configuration:

    • Ensure that the authentication method and credentials used for the OData connection in Power BI Desktop match the credentials required by the OData service. Double-check that the username and password are correct.
  4. Gateway Mode:

    • "Gateway Cluster Name: personal mode" indicates that you are using the Personal Gateway mode. In this mode, the computer running the gateway must be turned on and connected to the internet for automatic refresh to work. If the computer is off or not connected, automatic refresh will fail.
  5. Scheduled Refresh without Gateway:

    • If you want to enable scheduled refresh without relying on a computer being turned on, you should consider using the Power BI On-premises Data Gateway (Standard Mode). In Standard Mode, you can configure a scheduled refresh even when the computer is not online. This is suitable for scenarios where the computer may not always be available.
  6. Troubleshooting the Save Button Issue:

    • If the "Save" button is not working when configuring the OData connection, it could be a technical issue with your Power BI Desktop installation. Try restarting Power BI Desktop or repairing/reinstalling it if necessary.
  7. Permissions and Roles:

    • Ensure that the user account you are using to access the data source has the necessary permissions and roles assigned within the OData service.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors