Forum Discussion
Solved
Reduce PBIX file size
Hi Team, The data has been taken from SQL Server, and my two PBIX file size is (2591219KB,1962302KB) very large. I would like to know how to reduce the file size. I have already removed unused co...
Another option is to use Direct Query instead of Import. This way the data is stored in the SQL database, not in the cloud.
Another option is to use Direct Query instead of Import. This way the data is stored in the SQL database, not in the cloud.
This data also contains blob photos, which I've converted to base64, and that's only possible with import, not direct query. Please suggest reducing the data size.
composite mode, ie photos in import mode, data in direct query mode
However, it's still not working.
