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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

0

Data Refreshing Issue

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: Delivered

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

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

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

Hi @v-yetao1-msft ,

 

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

 

 

v-yetao1-msft
Community Support

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

Hi @v-yetao1-msft ,

 

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

v-yetao1-msft
Community Support
Status changed to: Accepted

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

Hi @v-yetao1-msft 

 

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

 

Thanks,

 

Joseph

v-yetao1-msft
Community Support
Status changed to: Delivered

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

Hi @v-yetao1-msft ,

 

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

 

Thanks,

 

Joseph