cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amz_123 Regular Visitor
Regular Visitor

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
Super User
Super User

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 Datanaut!"
Community Support Team
Community Support Team

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.

Amz_123 Regular Visitor
Regular Visitor

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

Super User
Super User

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 Datanaut!"
Amz_123 Regular Visitor
Regular Visitor

Re: Schedule Refresh Error

Hi @GilbertQ

Yes, Authentication works successfully

Super User
Super User

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 Datanaut!"