For the last few days, PowerBI Service won't refresh my dataset and give me this error:
"You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Query contains unsupported function. Function name: Resource.Access"
The "Gateway Connection" and "Data source credentials" disappears as well.
My setup is that I use personal data gateway to allow for Python script in my query to automatic refresh in PowerBI Service. I use Import Data mode. Automatic scheduled refresh on PowerBI Service has been working with this dataset for a long time until recently. I also have the latest Personal Data Gateway update (Oct 2022)
What I notice is that now if I remove Python script task in my query and republish, PowerBI Service will show all the data source credentials and allow for automatic refresh again.
Has anything changed in PowerBI Service that no longer allows for automatic refresh for Python script? Power BI data sources - Power BI | Microsoft Learn from this list it looks like it's still supported.
Please let me know if I can provide any more information to help root cause this. Thank you!
Solved! Go to Solution.
quick update: so there is a fix being rolled out and resolved the issue on my end (specifically for report with Python connection). Hopefully the roll out for all envs/clusters will complete soon and address yours as well.
Just wanted tor report that this issue now appears to be fixed. As of April 1st, 2023 my published reports with Python connectors are refreshing again on a daily set schedule. Thank you!
As of today (Feb 25, 2023) the problem with the Python connector still exists. The refresh fails with this message:
You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for Query1
The connection is via a Personal Gateway.
I have reviewed the requirements/restrictions as posted by Caitlyn from Microsoft in this thread (thanks, very useful!), and the only external package my script is using is Pandas, which, of course, is the foundation of the Python scripting in Power BI.
So, as of today (Jan. 25, 2023), the problem with Python scripts in a query still exists.
Hi @ngtrinh ,
There are a handful of requirements and limitations for Python packages:
Please make sure you’ve installed the correct one.
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Your post is very helpful, thanks for that.
However, I do not think it qualifies as the Accepted Solution for this specific question.
For some of the people on this thread (like myself), the refresh was working before and now it is broken.
I would suggest that you re-post your comments under a new question: "Reasons why a report which contains a query with Python script cannot be refreshed in the web"
I am also facing the same issue from yesterday (12/2/2022). Anyone got any solution for this, much appreciated if you can share this
Thanks a lot
Thanks Caitlyn for the pointers!
I did use Python 3.7.7 and the Python packages are published in PyPI. It was a bit odd because it used to work fine until recently (around Nov 15th week).
Note that I can also repro the issue by following this tutorial from PowerBI doc, using the provided pbix and csv file in the tutorial:
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!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.