Forum Discussion
Python crashes only after Transforming data + alternative for loading data when viewing mobile app?
I have Power BI run a Python script (that calls API endpoints) as a source. The Python script executes as expected and Power BI runs it well and loads all Pandas tables. Oddly enough, after I Transfo...
Thank you. The script will load all historical data and then only load updates (eg every few minutes). What is the best way to store this data in the cloud, and have Power BI load from that cloud file, also to ensure that, when opening the mobile app, no API calls need to be made/the report loads fast? Do I store an Excel/CSV file in OneDrive, and connect Power BI? What is the standard way of doing this?