cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RahilBukhari Regular Visitor
Regular Visitor

On Premise Tabular Data Refresh Set Up (not live, but imported)

Hi

I have built a Power BI Desktop model by importing data from a Tabular model. I've then published this to Power BI online and I expect the Schedule Refresh to pick up updates by quering the on premise Tabular model periodically.

 

I know about the live connection to on premise tabular and we have the Enterprise Gateway installed which works perfectly fine. However the Model that I have published is unable to do a refresh as it complains about the credentials.

 

On clicking the Schedule Refresh you have the option to "Connect Directly" or "Use an Enterprise Gateway". "Connect Directly" gives you the option to edit the credentials but neither Windows or Basic seems to work and "Use an Enterprise Gateway" (i select our gateway) doesn't give the option to edit the credentials which is expected, but the refresh doesn't work in either case.

 

Appreciate some guidance on how best to configure a Schedule Refresh for a Model dataset which is sourcing its data from an on premise SSAS Tabular model.

 

Thanks.

2 REPLIES 2
Power BI Team dimazaid
Power BI Team

Re: On Premise Tabular Data Refresh Set Up (not live, but imported)

Hi Rahil,

When you select the Gateway to do a scheduled refresh, you say "refresh doesn't work". What error do you see? 
Thanks,
Dimah 

RahilBukhari Regular Visitor
Regular Visitor

Re: On Premise Tabular Data Refresh Set Up (not live, but imported)

Hi Dimah

Surprising it has started working without any configuration changes. I point to the enterprise gateway when setting up the schedule and now it refreshes without any issues. Previously it was complaining about "the credentials in the cloud are missing" but that wasn't the case because the gateway was up and running and worked with live on premise reporting.

 

Thanks.

Rahil

Helpful resources

Announcements
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