Forum Discussion
Connecting to Datasources and importing data
Resolver IIHi Anonymous ,
When you import a file into Power BI, the VertiPaq engine applies compression. So if your csv is just over 1 GB, it's worth trying to import it anyways. The average compression ratio of Power BI is between 10:1 and 20:1.
When using DirectQuery (since you're reading the source) there is no data volume limitation, although performance might suffer severely if you're not slimming down your dataset to what you actually need in your report. When just using Azure SQL as a datasource, make sure to support the database with good indexes to help the performance. If you import from a SQL DB, you'll have the same import limitations as a csv.
If you have the option of using SSAS in combination with a SQL Server, that would be the easiest in terms of size and performance in my opinion and experience.
Sincerely,
Maurice
Did I answer your question? Mark my post as a solution!
by a ratio of 10:1 does it mean i can have a csv file of a size up to 10 gb?That would be interesting actually
- MauriceMecowe
Anonymous
If the compressions is at the rate which I mentioned before, you should have a chance of that to work!
Let me know if it works 🙂