Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sertank
Frequent Visitor

can't get scheduled refresh working (table schema unexpected error)

Hi to all,

 

After googling for results for couple of days and reading all the online tutorials and guides, I couldn't solve my problem and decided to post here.

 

I've installed Power BI Reports Server and created a report. The report gets data directly from SQL server via import (not direct query).

The report works fine local also I can publish it on report server.

I put priviledged account details into "Data Sources", test the connection and it connects successfully. However, wher I configure scheduled refresh, it can't refresh data. The error is "Data refresh failed. Please try again later or contact your administrator."

"SessionID: a078eba9-3b8a-460c-8cd2-e8cf6d9f73bd [0] 0: Connection string discovery: table schema unexpected."

 

Also the log file output is below:

 

2021-08-20 00:00:07.3863|INFO|11|Handling event with data: TimeEntered: 19.08.2021 21:00:00, Type: Event, SessionId: 0bc961b2-bd55-4536-9198-aec5750f7d0e, EventType: DataModelRefresh
2021-08-20 00:00:07.4123|INFO|11|Processing Data Model Refresh: SessionId: 0bc961b2-bd55-4536-9198-aec5750f7d0e, Status: Starting Data Refresh.
2021-08-20 00:00:07.4123|INFO|11|Processing Data Model Refresh: SessionId: 0bc961b2-bd55-4536-9198-aec5750f7d0e, Status: Starting Retrieving PBIX AsDatabaseInfo.
2021-08-20 00:00:07.4643|INFO|44|Finding model for refresh with catalogId=21e08903-82be-4c58-a1ad-f7a340b6f8df, lastCatalogItemUpdate =19.08.2021 09:46:10, lastModelUpdateinCatalog=19.08.2021 09:46:16, resolved to database name=21e08903-82be-4c58-a1ad-f7a340b6f8df_949828950, wasInMemory=True
2021-08-20 00:00:07.4713|INFO|11|Processing Data Model Refresh: SessionId: 0bc961b2-bd55-4536-9198-aec5750f7d0e, Status: Starting Verifying all the data sources are embedded.
2021-08-20 00:00:07.4952|INFO|11|Processing Data Model Refresh: SessionId: 0bc961b2-bd55-4536-9198-aec5750f7d0e, Status: Starting Verifying connection strings are valid.
2021-08-20 00:00:07.5072|INFO|11|Processing Data Model Refresh: SessionId: 0bc961b2-bd55-4536-9198-aec5750f7d0e, Status: Starting Streaming model to Analysis Server.
2021-08-20 00:00:07.6132|INFO|15|LoadDatabaseAsync: Successfully EnsureDbLoaded clientSessionId=0bc961b2-bd55-4536-9198-aec5750f7d0e, databaseName=21e08903-82be-4c58-a1ad-f7a340b6f8df_949828950, modelId=1413506852, alreadyLoaded=True
2021-08-20 00:00:08.2188|INFO|11|Processing Data Model Refresh: SessionId: 0bc961b2-bd55-4536-9198-aec5750f7d0e, Status: Starting Refreshing the model.
2021-08-20 00:00:08.6142|INFO|11|GetDataSourcesCollection: databaseName=21e08903-82be-4c58-a1ad-f7a340b6f8df_949828950, PowerBIDataSourceVersion=PowerBI_V3
2021-08-20 00:00:08.6454|ERROR|11|Error Processing Data Model Refresh: SessionId: 0bc961b2-bd55-4536-9198-aec5750f7d0e, Status: Error Failed to refresh the model, Exception [0]Microsoft.AnalysisServices.Azure.Common.DataSourceDiscoveryException: Connection string discovery: table schema unexpected.
TemplateMessage: Data source discovery failed on database .

 

 

Any help will be greatly appreciated.

 

Sertan

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @sertank ,

 

What's your browser language? Is it "Turkish"?

 

If so, there is a bug in RS Jan 2021. Please update to the latest version: 15.0.1106.169, it is fixed in this version.

 

If not, please let me know.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
FarhanAhmed
Community Champion
Community Champion

Can you please check if any other data source is refreshing fine? like Excel.

 

What is the version of PBIRS you are using? Are you able to successfully connect to SQL Server from PBIRS machine?

 







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

Proud to be a Super User!




Thanks for your comment Ahmed.

 

I'm able to connect SQL Server from PBIRS (15.0.1105.195 version) successfully. Also I can connect from PBIRS Reports - Manage - Data Sources screen successfully.

 

We are not using any Excel for now.

What is the version of PBIRS you are using ?

 

The user that you are using in both PBIRS & Report Server is same?

 

Are you trying to connect to On-Prem SQL Server or Azure SQL ?

 

I think this may be a bug, you can also post your query at 

 

Issues - Microsoft Power BI Community

 







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

Proud to be a Super User!




Hi Ahmed,

 

The version we're using is PBIRS on premise and build number is 15.0.1105.195.

I'm using a local account on PBIRS server and SQL authentication when connecting to SQL.

Our SQL server is on premise as well.

 

I'll check the issues page and report as a bug and hopefully get a response.

Icey
Community Support
Community Support

Hi @sertank ,

 

What's your browser language? Is it "Turkish"?

 

If so, there is a bug in RS Jan 2021. Please update to the latest version: 15.0.1106.169, it is fixed in this version.

 

If not, please let me know.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors