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.
I am using a Sharepoint folder for several queries and it has been working fine. Then it would randomly give a request failed error and I would need to wait a while or clear permissions and reenter my credentials. Now it's everytime I add another step to a query and takes hours for simple changes.
Are there API Call limits? Any other ideas?
I swapped the source line in the advanced editor for the queries to use the local files as a temp solution.
The error is:
An error occurred in the ‘xxxxxxxxxx’ query. DataSource.Error: SharePoint: Request failed:
@salty , refer if these two can be bit of help
https://community.powerbi.com/t5/Power-Query/SharePoint-list-limitations/td-p/724174
https://community.powerbi.com/t5/Desktop/power-bi-file-size-limits/td-p/108820
I am sure there are limits, but I doubt you'd hit those with Power BI as it should log in once for each session, not each call to the data. I've not seen that error. You might want to talk to your SharePoint admin and see what they have to say.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |