Forum Discussion
Datasets Failed to refresh
After a few support ticket calls, the solution is found!
In Power BI Web, Set the Privacy Level setting for all my data sources to "Public" and then the Scheduled Refresh worked!
So, on this screen, scroll to the bottom,
expand Advanced Settings, and Set the Privacy Level setting for all my data sources to "Public" and then the Scheduled Refresh worked!
Hope this helps everyone who has this problem!
dc7669
I opened a support ticket about it.
The Microsoft contractors were looking at permission setting of my different data sources in my Data Gateway, but I think it is not the cause of the error as the Power BI Desktop still can update without any problem. When I published from Power BI Desktop to Power BI Service, the data is all current. ut, if I were to refresh in Power BI service, the error occurred.
Also, I published the same dataset from Power BI Desktop to Power BI Service without the "Merge tables". Then, Power BI service can refresh without problems.
Thus, it seemed to me that the "merge tables" function is causing the failure.
I suspect this is caused by some backend stuffs, which may take the next update to fix.
I guess my temporary solution is manual publishing of the Power BI Desktop to Power BI Service.
dc7669
After a few support ticket calls, the solution is found!
In Power BI Web, Set the Privacy Level setting for all my data sources to "Public" and then the Scheduled Refresh worked!
So, on this screen, scroll to the bottom,
expand Advanced Settings, and Set the Privacy Level setting for all my data sources to "Public" and then the Scheduled Refresh worked!
Hope this helps everyone who has this problem!
dc7669
Worked for me! Thank you
Hi,
I cant find this screen in Power BI Web.
From Setting (the gear icon) in top right of Power BI Web. From the menu, select "Manage Gateway". Then, Expand "Gateway Cluster" and then click on one of the Data source. Then, you will see the above screen.
thanks a million - I've been stuffing around with this for a day - works.
