cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Petebro
Microsoft
Microsoft

Power BI Report Server October 2020 update has been released.

Hello,

 

I am pleased to announce we have released an update to the Power BI Report Server (October 2020) with several fixes to problems commonly reported here on the Power BI Community Forums.  The release can be found here:

https://www.microsoft.com/en-us/download/details.aspx?id=57270

 

Changelog will be updated tomorrow with the following information: 

 

Version: 1.9.7627.11028 (Build 15.0.1104.264), Released: November 18, 2020
        - Bug fixes
            - Fixed issue preventing users from changing fields in site settings via the portal.
            - Fixed issue with refresh of Power BI Reports when using 'EnterData' data source.
            - Fixed issue with refresh of some models using enhanced dataset metadata.
            - Fixed issue where some Power BI reports could not be published to the Report Server from Power BI Desktop
 
Thanks for being active part of the Power BI community and please let us know if you run into any problems.
 
-Pete
97 REPLIES 97
cm6431
Regular Visitor

Upgraded Power BI Report Server and confirmed Version: 1.9.7627.11028  is now installed.

Chose Manage for an existing report then confirmed Data Sources credentials are correct and connection tested successfully. Attempted a Refresh Now and received this error:

 

SessionID: 6bbca19a-154f-4758-bb4c-a62cbbe06ae3
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
[1] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
[2] -1055784828: The database operation was cancelled because of an earlier failure.

 

Installed Microsoft Power BI Desktop (October 2020) (x64) version 2.86.1321.0.  Chose Edit in Power BI Desktop and Refreshed All.  Confirmed data refreshed, saved, and closed.  Succesfully tested credentials again, and attempted to Refresh Now, only to receive similar error.  Tested reports with Teradata data sources then tested with Vertica sources using direct connection and ODBC.  All fail with error regarding "No credentials were found for the datasource."

Still have hundreds of unhappy users with non-working reports in a corporate environment.

@cm6431 , 

We also have the same problem. everything works good except when we schedule refresh the reports. Then we receive meaningless errors like "Data source not found", "Credintioals are not correct", "There is no data available in the database" or even "An element with the same key has already been added"

Petebro
Microsoft
Microsoft

My mistake I thought it did. I sent you a PM. It's possible the credentials weren't saved after you tested the connection. Reenter the credentials, click save, then click test connection to ensure they are working.

Hi Pete, 

 

Yes I did save. Power BI RS doesn't allow creating scheduled refreshes unless I provide valid saved credentials in the Data Sources.

 

Regards,

Modasher.

Petebro
Microsoft
Microsoft

Would it be possible you could PM me the PBIX report you are facing the issue with as we are unable to reproduce this issue after the uodate locally.

Hi,

Please find the attachments (images) I have sent to you via PM. Please be advised that it has to be a mapped drive as auto refresh/scheduled refresh don't work on local drive. Hope that helps. 

 

A few items to investigate could be:

- mapped drive

- transformed data in Query editor

- folder as source (with spreadsheet inside)

- Scheduled refresh

 

Regards,

Modasher.

Hi Petebro,

It seems that PMs don't support zip or pbix files. Could you please advise how to communicate with you.

 

modasher_0-1605841967824.png

 

The issue occurs for all the reportes when the pbix has transformed spreadsheets in the Query editor. 

I will need to create a sample to demonstrate that, but can't share the pbix file for confidentiality.

 

Could you please advise what do you mean by update locally? I can refresh the data from Desktop, but from server it doesnt run the scheduled refresh.

modasher
Advocate I
Advocate I

Hi,

 

I can confirm that the issue still exists where the sources are folder types. 

 

Regards,

Modasher.

modasher
Advocate I
Advocate I

Hi I have the following Server versions and the latest Power BI Desktop versions as well. The refresh for a few of the sources such as folder (with spreadsheets taken in as legacy) are not refreshing via server, but are refreshing via desktop. 

modasher_0-1605837387234.png

 

modasher_1-1605837522483.png

modasher_2-1605837567423.png

 

 

Regards,

Modasher.

Petebro
Microsoft
Microsoft

Strictly speaking the refresh errors as well as the publish from desktop errors will be fixed by applying the server fix only.

 

With that said it's always recommended to also have the latest desktop.

blairblair
Helper I
Helper I

@Petebro , do we just need to update report server or do we need to download desktop as well?

Petebro
Microsoft
Microsoft

  1. Are you having issues with all reports or just this one?
  2. Can you say the types of datasources found within this report?
  3. Anything different/unique as it related to datasources connectivity in it?
  4. I assume the refresh fails consistently as well even after the restart of the server?

Hi,

 

The issue exists for the datasources which are using folder/spreadsheets.

 

Regards,

Modasher.

bryanshaw46
Helper II
Helper II

bryanshaw46_0-1605813507987.png

its gone again and I just found it and connected

 

Petebro
Microsoft
Microsoft

Before you connect to PBIRS  they will be hidden, but show up when you connect to the instance. Perhaps this is what you saw.

 

config2.PNG

Yep, that is it.

bryanshaw46
Helper II
Helper II

ok, that is just too weird.  Now they are there.  This morning, they were not.

bryanshaw46
Helper II
Helper II

The Scaled Out and the Power BI Cloud tabs are missing in the Report Configuration Manager

@bryanshaw46 Can you provide a screenshot? After you connect to the PBIRS instance the options should show up per usual.

 

config.PNG

Petebro
Microsoft
Microsoft

Ah that may be because of a limitation listed here. I've filed a bug for a future release to return a better error message for this error in refresh.

 

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

 

Power BI Report Server has a limitation when using web data: only data files from web can be refreshed. Data based on Page or By example aren't refreshable. This limitation is because the M expressions created with Web.BrowserContents and Web.Page can't be refreshed. Power BI Report Server can only refresh Web.Contents data sources.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

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