Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

0
Joseph_Chau

Data Refreshing Issue

Submitted by on ‎06-23-2022 11:22 AM

I don't know why, but I have to use a Desktop Client from Oct 2021 to refresh a specific report. The client for June 2022 is still  giving me these errors and any help would be appreciated:

Joseph_Chau_0-1656008297264.png

AssignmentNumber
Microsoft SQL: Invalid object name 'sys.extended_properties'.
CheckerInformation
Microsoft SQL: Invalid object name 'sys.extended_properties'.
SummaryReport_NEW
Microsoft SQL: Invalid object name 'sys.extended_properties'.
Report_Archive
Microsoft SQL: Invalid object name 'sys.extended_properties'.
MeasuresTbl
Loading blocked by failures with other queries.
EventLog
Microsoft SQL: Invalid object name 'sys.extended_properties'.
TabletData
Microsoft SQL: Invalid object name 'sys.extended_properties'.
R_Lines
Microsoft SQL: Invalid object name 'sys.extended_properties'.
Tablet Logon Logoff
Microsoft SQL: Invalid object name 'sys.extended_properties'.
Status: Done
See more ideas labeled with:
8 Comments (8 New)
Comments
Anonymous
Not applicable
‎06-23-2022 11:47 PM

Hi @Joseph_Chau 

Can you refresh your data normally before ? What is your data source ? What is the connection mode you connect to your data source ? No related known issues have been found so far .

 

Best Regards,
Community Support Team _ Ailsa Tao

Joseph_Chau
Frequent Visitor
‎06-24-2022 10:08 AM

Hi @Anonymous ,

 

Yes I was able to refresh before.

 

With my report, I can make changes to the visuals, measurements, and publish without any issues. The only issue I have is when I try to refresh the data before publishing onto my workspace. Once its been published to my workspace, I can then refresh the dataset on the web with no issues.

 

Joseph

 

 

Anonymous
Not applicable
‎06-27-2022 12:44 AM

Hi @Joseph_Chau 

So you can refresh normally on the Service, but an error is reported when you refresh on the Desktop? Did you make changes to your Desktop? Like updating to the June version?

 

Best Regards,
Community Support Team _ Ailsa Tao

Joseph_Chau
Frequent Visitor
‎06-27-2022 07:48 AM

Hi @Anonymous ,

 

Yes, the issue is when I try to refresh using the June Desktop Version. If I refresh using the Oct 2021 Desktop version, there are no issues.

 

Thanks,

Joseph_Chau

Anonymous
Not applicable
‎06-27-2022 10:42 PM

Hi @Joseph_Chau 

The June version has some problems when opening report or loading data. It is currently being fixed. If there is any news, I will come back and reply. The current solution is to downgrade to a Desktop that you can use normally.

 

Best Regards,
Community Support Team _ Ailsa Tao

Joseph_Chau
Frequent Visitor
‎06-28-2022 07:02 AM

Hi @Anonymous 

 

This issue was also present in the May version as well. Looking forward to hearing back.

 

Thanks,

 

Joseph

Anonymous
Not applicable
‎07-25-2022 06:33 PM

Hi  @Joseph_Chau 

This issue has been fixed , please update your Desktop to latest version and try again .

 

Best Regards,
Community Support Team _ Ailsa Tao

Joseph_Chau
Frequent Visitor
‎07-25-2022 08:07 PM

Hi @Anonymous ,

 

I will test it soon. I was able to work around this by creating an ODCB connection.

 

Thanks,

 

Joseph

Idea Statuses