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

Power BI for Office 365: Refresh not working consistently

Hello fellow Power BI users,

 

I have two on-premise SQL Server databases defined as Data Sources in Power BI for Office 365. The Gateways and Data Sources are healthy.

 

One of the developers created a test workbook and I can refresh it but he cannot. Also, when I schedule the recurring refresh it works, albeit inconsistently. We are using the same SQL Server account in the Data Source as well as the Workbook.

 

So we actually have two issues -

1. The refreshes don't work consistently as you will see in the screenshot. Sometimes they take too long...I wonder if this is due to instability / ongoing issues in the office 365 power bi platform. There has been a service degraded message for a few days. But no way to figure out exactly what's going on. Also, I am aware that refresh time will depend on the latency between the Office 365 SharePoint site and our on-prem data source.

 

2. Can't figure out what's wrong with my developer unable to refresh. I am the admin. The connection string in the workbook and the data source is the same since I am able to refresh it. I also added him into the Global Adminstrator Group to see if that helps but no dice.

 

3. The Power BI pages seem to be rendering in Spanish frequently without any changes on our part. Wondering if anyone else is having these problems.

 

Errors.png

 

Any and all assistance will be greatly appreciated.

 

Tks & Rgds,

 

Alay

1 ACCEPTED SOLUTION

Accepted Solutions
Alay Regular Visitor
Regular Visitor

Re: Power BI for Office 365: Refresh not working consistently

This is now resolved. The resolution was to modify each data source and add the developer under users and group. Thank you to all that read and attempted to assist.

View solution in original post

4 REPLIES 4
Highlighted
Alay Regular Visitor
Regular Visitor

Re: Power BI for Office 365: Refresh not working consistently

Sorry...typo above. 3 issues (instead of two.)

Super User IV
Super User IV

Re: Power BI for Office 365: Refresh not working consistently

I have seen a few other posts on the Spanish thing, I have not seen this myself but I know some other people have reported it, unless you were that people...

 

http://community.powerbi.com/t5/Service/Spanish-language-showing-up-periodically/m-p/2301#M651

 

On the other side of things, it sounds like your developer does not have access to the SQL Server but that doesn't sound quite right. Sounds like you are using an Excel file and is your developer searching for the data source and downloading the query and then trying to use it?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Alay Regular Visitor
Regular Visitor

Re: Power BI for Office 365: Refresh not working consistently

change_report_error_Message.pngThanks for the tip on the Spanish issue. Regarding my developer, he's created the workbook. We validated the connection string on the data sources and his workbook which contains  the power pivot table & visualization is the same. But when he tries to refresh it on the SharePoint / Power BI for Office 365 site, he gets an error. But I don't....The userid and password we are using is the same so it made us wonder if something's wrong with the SharePoint / Power BI Site. I even tried making him an owner of the SharePoint site but no dice.

Alay Regular Visitor
Regular Visitor

Re: Power BI for Office 365: Refresh not working consistently

This is now resolved. The resolution was to modify each data source and add the developer under users and group. Thank you to all that read and attempted to assist.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

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
Top Kudoed Authors