Forum Discussion
Solved
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 limita...
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.
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
ok, yes i understood that part - sorry, I meant if we decide to leave our data on premise
