topic Re: Schedule Refresh Error in Service

Schedule Refresh Error

Amz_123 — Thu, 07 Feb 2019 05:00:09 GMT

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.

Thanks In Advance,

Amz

Re: Schedule Refresh Error

GilbertQ — Thu, 07 Feb 2019 06:24:19 GMT

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?

Re: Schedule Refresh Error

v-yuta-msft — Fri, 08 Feb 2019 02:32:11 GMT

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.

Re: Schedule Refresh Error

Amz_123 — Fri, 08 Feb 2019 04:29:45 GMT

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.

Thanks In Advance,

Amz

Re: Schedule Refresh Error

GilbertQ — Sat, 09 Feb 2019 04:37:37 GMT

Hi there

Does the authentication work successfully?

Re: Schedule Refresh Error

Amz_123 — Sat, 09 Feb 2019 09:43:54 GMT

Hi GilbertQ

Yes, Authentication works successfully

Re: Schedule Refresh Error

GilbertQ — Sun, 10 Feb 2019 23:38:23 GMT

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