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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Refresh will not happen with one report. but it will refresh manually.

Cluster URI: WABI-WEST-US-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 30004004-3e5c-4503-877f-1bd2351bce20
Request ID: 118f80a3-7436-cbcd-965d-062ccf7a2557
Time: 2022-04-18 21:30:36Z

Status: Investigating

Hi @sbrown ,

 

According to your error message, I found some troubleshooting ideas provided by other users  on the forum, you can see if you can solve your problem according to these steps.

 

1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)

2 - Refresh the data in the desktop and save.

3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.

4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online

5 - Hop back to PBI Online and set the refresh schedule back up.

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @sbrown ,

 

It would be great if you could provide more detailed information on this issue.
What data source are you using? What is the connection mode?
Did this problem happen suddenly? Was this report refreshed properly before?
Have you done a simple test to see if other reports from the same data source refresh properly?

 

Best Regards,
Community Support Team _ Caitlyn

sbrown
Regular Visitor

Hi,

 

The data source is ODBC Oracle- a cloud-based server.

It seems there is an issue with the forecast feature on the display. When I select the forecast feature the display will not show. Screenshot below.

Besides that, the report will not refresh on its own. I must manually drop the file and reload it.

 I have several other reports connected to the same data source that is refreshing the same. It is used to refresh.

 

sbrown_0-1650376306388.png

 

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

Hi @sbrown ,

 

Power BI users using Line chart visuals in shared workspace with Forecasting feature enabled may see visuals load failing.

 

Workaround:
1.Users can recreate the Line chart visual without the Forecasting feature and the visual will load as expected.

2. Move the report to premium workspace.

 

Engineers are working on the fix, ETA will be updated once available.

Best Regards,
Community Support Team _ Caitlyn

sbrown
Regular Visitor

Do you have to purchase a premium workspace to do this? 

 

sbrown
Regular Visitor

I took off the forecast feature. The report still will not refresh. With the same error message. 

sbrown
Regular Visitor

I have another report where the forecast feature is not working. 

 

sbrown
Regular Visitor

Now other reports are starting to fail with the same issue: 

sbrown_0-1650473670918.png

 

v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @sbrown ,

 

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

sbrown
Regular Visitor

Your process does not allow me to submit a ticket! ... There is no solution for this? 

v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @sbrown ,

 

According to your error message, I found some troubleshooting ideas provided by other users  on the forum, you can see if you can solve your problem according to these steps.

 

1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)

2 - Refresh the data in the desktop and save.

3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.

4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online

5 - Hop back to PBI Online and set the refresh schedule back up.

 

Best Regards,
Community Support Team _ Caitlyn