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,
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.
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,
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!