Hi @PeterF1 ,
Do you want to get through threshold row limit of sharepoint in powerbi?
Could you tell me in details about threshold row limit of sharepoint?
As far as I known, sharepoint has these limits:
For a large Sharepoint list, it may slow down the performance for the report.
Power BI for Large SharePoint lists
"Power Query specifications and limits".
Users can upload files to Power BI service up to 1 GB in size per file.
Please learn more here: Limitation of data size in the Service
To improve the performance for large sharepoint list data,
Besides your method,
You could connect to sharepoint list with Power BI in direct query.
sharepoint-real-time-reporting-with-power-bi
If you want to use powerapps to display data in sharepoint list in powerbi, you could do this:
1)embed a canvas app in powerbi
2)in this embed canvas app
connect with sharepoint list
save data in sharepoint list to collection: //powerapps has delegation limit, use collection could avoid this
ClearCollect(collection1,listname)
display this collection in your app
Best regards,
