Forum Discussion

Maggi029's avatar
Maggi029
Icon for Helper II rankHelper II
4 years ago

How power BI handle large DataSet?

Because I'm using elastic search as my database, I'll need to create historic data visualisation. Every week, I will push about 30MB of json data into the elastic search index, and I have imported my...
Need Help
Maggi029's avatar
Maggi029
Icon for Helper II rankHelper II
4 years ago

Hi nicpenning 

 

Thanks for look into this,

 

Previously, as you suggested (Solved: Re: Getting Data from Elastic Stack with REST with... - Page 2 - Microsoft Power BI Community), I used the rest api to import the data from elastic search. However, I was unable to refresh the data in the PowerBI online service using this method because recursive calls turn this datasource into dynamic data, and PowerBI fails to refresh dynamic data. As a result, I rely on the Python method. Do you believe my request can still be fulfilled using the REST API, and if so, could you please elaborate?

nicpenning's avatar
nicpenning
Icon for Helper I rankHelper I
4 years ago

I am not familar with the dynamic data source or the online PowerBi service, so I won't be much help here. I hope you can find a solution soon!