Share
ReportHello Experts,
Good day. I thought I will ask this question in this forum to get proper solution. I will try to explain in a brief way.
Scenario:
We have data as excel in SharePoint. The data is very large and dynamic(as of now we have above 1lakh,it goes increase day by day). we have power BI reports for the same data. The data source to power Bi also from SharePoint.
Alternatives we tried to connect the data as a data source are the following:
1) Excel has some limitations that it reads only 2MB and some delegation issue till 2000 records. Calculated formulas also it wont support.
2) SharePoint as a data source, it has its own limitations that for above 20000 rows and for dynamic data it wont be a good data source.
3) Tried importing Power BI tile to PowerApps, comes to know that filtering is only available on pinned visualization tiles, not supported for pinned reports.
Now we are thinking to use pivot table as a data source. (if we create pivot table on top of the master data, we get the data as small). Tried it but the PowerApps was not allowing pivot table as a data source. not reading pivot table as a normal excel.
Question:
1) Pivot table with refresh the data into PowerApps. Is it possible ?
2) Is there any alternative way to read all my data as a data source?
correct me if i am wrong in any case. Can you guys please help me on this?
All responses (
Answers (
342
