cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Organization Content Packs and Gateway Refreshes

In this Power BI Support article, it talks about creating an organizational content pack and how the owner can set the refresh schedule. I'm confused - can a dataset/report that uses an enterprise gateway for access to on-prem data be set up so that it caches the data for a period of time and then refreshes according to schedule? I don't see any option for that; it seems that it is always hitting the on-prem data source.

 

I know that I can do this using my personal workspace and a personal gateway. But I'm creating a content pack for Power BI Pro users within my organization and want to set a refresh schedule this way without constantly hammering an on-prem data source. Any options here? Thanks.

1 ACCEPTED SOLUTION
Resident Rockstar
Resident Rockstar

From the Power BI Gateway - Enterprise documentation page:


Currently, the gateway allows for the use of DirectQuery to an on-premises SQL Server or SAP HANA, as well as a live connection to Analysis Services. You can use a live connection to either a tabular or multidimensional model in Analysis Services.

Looks like you're not yet able to use the Enterprise Gateway for hosted data models.

View solution in original post

5 REPLIES 5
Resident Rockstar
Resident Rockstar

Live explore (SSAS) and DirectQuery (SQL of various flavors, SAP HANA, other DBs coming) will always query the source system directly. These are available in the Enterprise Gateway.

 

You do not have to use a live connection to these sorts of data sources. You can choose to Import data rather than use one of those connection types. Imported data will be stored locally in a .pbix file, and when that .pbix file is uploaded to the Power BI Service, you can set up a scheduled refresh, so that a copy of the data is stored on Microsoft's Azure infrastructure.

I've tried importing data and uploading that pbix file within my organization's workspace, but the problem is that when I try to refresh or set up a refresh schedule, it prompts me for a Personal gateway. This doesn't make sense for organizational reports - I want to use the Enterprise gateway, not a Personal gateway. Is there a work around?

 

Here's the message I get:

"Couldn't refresh because your Personal Gateway is offline. Make sure your Personal Gateway is up and running."

Is your enterprise gateway configured to access the data sources ?

If not, use Manage gateway to configure the data sources and it should all work from there

Capture.PNG

 

Yes, it is. I'm already using the Enterprise Gateway that I've set up for DirectQuery reports:

 

PBI1.PNG

 

But I want to upload reports that were designed to Import data (i.e. not use DirectQuery mode) and work off a refresh schedule. And when I upload one of those reports and try to set up the refresh schedule, it prompts for a *Personal* gateway, even though I already have an Enterprise gateway set up and available using the same exact server/database name.

 

On a side note, I went ahead and set up a Personal gateway, and even though it shows the status as being online and the credentials being correct, it keeps failing when trying to manually refresh the data. It eventually times out.

Resident Rockstar
Resident Rockstar

From the Power BI Gateway - Enterprise documentation page:


Currently, the gateway allows for the use of DirectQuery to an on-premises SQL Server or SAP HANA, as well as a live connection to Analysis Services. You can use a live connection to either a tabular or multidimensional model in Analysis Services.

Looks like you're not yet able to use the Enterprise Gateway for hosted data models.

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors