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
Juramirez
Resolver I
Resolver I

Scheduled Refresh One gateway with different data source

Hi all!

 

I have a Gateway installed on a Windows server and it works fine! I have a doubt:

I have 3 Datasource asociated to this gateway so when i refresh Datasource A it consumes one of my eight refresh per day. This means that if I refresh one datasource, my refresh per day in all data sources are affected?  I mean refreshing Datasource A affect my refresh per day in Datasource B and Datasource C?


Regards

1 ACCEPTED SOLUTION

@Juramirez If you had 3 datasets that all pointed to the same datasource, you would have 8 refreshes per dataset. So, 24 total refreshes if you looked at it from a data source perspective. But I would encourage you not to think of it that way.

A DataSet gets 8x refreshes per day (for import connection type). It doesn't matter where it is sourcing the data from.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

4 REPLIES 4

@Juramirez Dataset vs. Datasource. You can refresh a  dataset (the combined sources of information in Power BI) up to 8x per day. If you have the same data source connected to multiple datasets, there is no restriction.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer Thanks for your answer. So, if I have my On Demand Gateway which have 3 datasources and I have 3 datasets that are connected to this 3 datasources (one to one), when I refresh one of this datasets doesn't affect the other datasets refreshes (I mean, you have 8x per day to refresh so if you have 3 datasets you have 24x refresh per day (one for each dataset/datasource) or 8x refresh per day (8 times to refresh per Gateway, no matter how many datasets you have). Can't understand this very well.

 

 

Regards

@Juramirez If you had 3 datasets that all pointed to the same datasource, you would have 8 refreshes per dataset. So, 24 total refreshes if you looked at it from a data source perspective. But I would encourage you not to think of it that way.

A DataSet gets 8x refreshes per day (for import connection type). It doesn't matter where it is sourcing the data from.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer Thanks for your answer, that's what I was looking for.

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.

Top Solution Authors
Top Kudoed Authors