cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Schedule Refresh Error

Hi Community,

I am having vast dataset connected from Azure Database. And my dashboard size is nearly 40 MB. I am getting trouble in setting Schedule Refresh. Based on Previous Queries from Community. I have downloaded the .pbix file from service and refreshed at Power BI Desktop. I didn't get error in Desktop. Manual Refresh works fine but while setting Schedule Refresh I am getting one of my table is error.

I also deleted Inactive Relationships from .pbix and republished.

Anyone has any idea to resolve the error. rather than these two methods.

Schedule Refresh.pngSchedule Refresh1.png

Thanks In Advance,

Amz

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: Schedule Refresh Error

Hi there

There appears to be an error on your table called "sale_list"

Could you confirm that because it is an Azure SQL Database that you are not using the On-Premise Data Gateway?




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

Proud to be a Super User!







Power BI Blog

Highlighted
Community Support
Community Support

Re: Schedule Refresh Error

@Amz_123,

 

Check if all the credentails is valid. In addtion, if the dataset contains different data source, also check if the other data source's credentails are valid.

 

Community Support Team _ Jimmy Tao

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

Highlighted
Helper I
Helper I

Re: Schedule Refresh Error

Hi @GilbertQ and @v-yuta-msft,

Again I have downloaded from service and refreshed the datasets manually in Power BI desktop. Everything works fine. While connecting Service I am getting error. I am using Non Pro Version. Since for connecting Azure Datasets its not necessary to set Gateway so I am using Non Pro Version.

 

@v-yuta-msft I have login through windows credentials in Power BI Service. Is I am going in right path its neccessary to login Azure dataset through windows credential or Ouath Credential? I am also using Google drive as another source. I didn't get any error in drive tables. I am getting error only in Azure Dataset. Anyone Please help me to set Schedule Refresh.

My Connection in Power Bi Service.

error.png

 

 Thanks In Advance,

Amz

Highlighted
Super User IV
Super User IV

Re: Schedule Refresh Error

Hi there

Does the authentication work successfully?




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

Proud to be a Super User!







Power BI Blog

Highlighted
Helper I
Helper I

Re: Schedule Refresh Error

Hi @GilbertQ

Yes, Authentication works successfully

Highlighted
Super User IV
Super User IV

Re: Schedule Refresh Error

I wonder if you had to enable the trial if it would refresh?




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors