Forum Discussion

elaj's avatar
elaj
Helper IV
2 years ago

Working together on same datasource

Hi,   we work as a team on our data. And because the query editor is not able to work with our typical survey data (too many columns), we structure the data with R (mainly verticalize it) to then l...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

Hello elaj,

 

Power BI Dataflows can be a good solution for team collaboration. You can create and schedule dataflows to refresh data from various sources, including the output of your R scripts. Dataflows also support storing data in Azure Data Lake Storage Gen2 (cost-effective option compared to other Azure services)


For the SharePoint issue with Parquet files, consider automating the process of converting Parquet files to a more SharePoint-friendly format if needed.

 

Also If you are avoiding heavy database solutions, consider using a lightweight database like SQLite. It's file-based, supports concurrent access, and can be a good intermediary storage solution.

 

Should you have any questions or further assistance, please do not hesitate to reach out to me.