Forum Discussion
File too big
Hi there,
the data i would like to analyze is in a CSV file and once loaded into Power BI Desktop the file is 346 MB.
I would like to publish it on Power BI Service but I cannot - since the limitation is 250 MB.
What are my options ?
Thanks in advance
Kim
You can utilize the Enterprise Gateway for a DirectQuery connection to a variety of relational sources, or with a live connection to an SSAS data source, either Multidimensional or Tabular.
6 Replies
Probably your only option at this time would be to load the CSV file into SQL, perhaps Azure SQL DB and use DirectQuery. This circumvents the data being loaded into Power BI and thus also circumvents the size limitations.
thanks.
When you say use DirectQuery, do you mean with Enterprise Gateway - if we move our data to SQL Server ?
Thanks so much
