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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Not able to schedule a refresh as well as gateway

Credential tab, and schduling refresh tab is disabled. and i am not able to create a gateway.

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

What is the data source in this dataset? If it is an on-premises data source, you need to use a gateway to perform refresh in service. From the screenshot, you don't have a gateway on your account, so you need to install an on-premises data gateway first. Add the local data sources to this gateway. Then you can map this dataset to the specific gateway to refresh. 

Install an on-premises data gateway 

Refresh data from an on-premises SQL Server database 

 

If the data source is a cloud data source and doesn't require an on-premises data gateway, you can set up credentials first. Then Schedule refresh option will be enabled. 

 

If you use Enter Data to create a table in a Power BI report and publish it to the service, this table is fixed and don't need to be refreshed. Setting up credentials is not necessary either. 

 

Can you please tell which data sources are used in the dataset? Can you click Show details above Refresh history to check the detailed error message?

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

What is the data source in this dataset? If it is an on-premises data source, you need to use a gateway to perform refresh in service. From the screenshot, you don't have a gateway on your account, so you need to install an on-premises data gateway first. Add the local data sources to this gateway. Then you can map this dataset to the specific gateway to refresh. 

Install an on-premises data gateway 

Refresh data from an on-premises SQL Server database 

 

If the data source is a cloud data source and doesn't require an on-premises data gateway, you can set up credentials first. Then Schedule refresh option will be enabled. 

 

If you use Enter Data to create a table in a Power BI report and publish it to the service, this table is fixed and don't need to be refreshed. Setting up credentials is not necessary either. 

 

Can you please tell which data sources are used in the dataset? Can you click Show details above Refresh history to check the detailed error message?

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Anonymous
Not applicable

No even i was not able to see those options eearlier.

kartikpatolia_0-1652191001327.png

 

PC2790
Community Champion
Community Champion

Can you share the screenshot?

Do you have the proper access? Were you able to see these options earlier?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.