Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
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.
I'm still having issues with scheduling a refresh using my personal gateway for a report that uses a python script as the data source.
I'm close to abandoning this option and moving to another solution on a different platform as this problem has been ongoing for almost 3 months now (since mid-dec 2022).
Anyone else facing this issue? I would hate to abadon this as it was working so well for me for several months prior.
thanks
Here is the result of my latest attempt:
Hello, I have the same issue as of 11/08/2023, and I don't know how to resolve it. I've read on several forums that I should use the gateway in personal mode, but I can't seem to fix it. In my case, I'm using a Python script that returns a dataframe with the information. If I update it locally, it works, and the data loads, allowing me to publish. However, if I try to schedule it, I get the same error as you. Have you managed to solve it, or did you eventually choose another option? If you opted for another solution, could you please share how you did it?
Thank you very much
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!
Not for me...
I am still getting this:
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.
Learn which Python packages are supported - Power BI | Microsoft Learn
Best Regards,
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.
Caitlyn,
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"
Hi Team,
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
Sunil
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:
Using Python in Power BI Power Query Editor - Power BI | Microsoft Learn
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |