Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning
Could you help me with the following problem:
I have published a powerBi report using DirectQuery and mariadb that is updated every 1 minute. The publication had been running smoothly for several days, but today the report stopped showing the data and shows errors that indicate that the visuals cannot be loaded. Additionally, the following text appears at the top: "PowerBi Premium backend servers failed. Please refer to the error details for additional information."
On the other hand, when I enter configuration -> Dataset, I no longer see the tabs to select the gateway and data source credentials and I get the following message: You cannot schedule refresh for this dataset because the following data sources do not support refresh: Query contains unsupported function. Function name: Resource.Access.
Solved! Go to Solution.
Hello, the bug has already been fixed, apparently it was a widespread problem of microsoft after an update.
Thank you.
Hello, the bug has already been fixed, apparently it was a widespread problem of microsoft after an update.
Thank you.
Hello
Thanks for the answer, check the link and the data source hasn't changed, so the problem doesn't go there.
Just to test, create a new file with a MariaDB data source without making any changes and using simple functions and the problem persists.
Checking the forum in English apparently I am not the only one to whom I pass that problem in recent days:
Best regards.
Hi @Syndicate_Admin ,
From your description, this data source seems to be updated frequently? If so, please check if some changes have occurred to the data source that are not supported by PowerBI and try reconfiguring the gateway and credentials for it.
For more details, please refer to:
Troubleshooting unsupported data source for refresh - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |