Data Refreshing Issue

[Joseph_Chau]

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:

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'.

[Ailsa-msft]

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]

Hi @Ailsa-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

[Ailsa-msft]

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]

Hi @Ailsa-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

[Ailsa-msft]

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]

Hi @Ailsa-msft 

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

Thanks,

Joseph

[Ailsa-msft]

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]

Hi @Ailsa-msft ,

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

Thanks,

Joseph