cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors