File too big

[kdelmotey]

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

[Greg_Deckler · Accepted solution]

I mean this:

https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/

[Greg_Deckler]

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.

[kdelmotey]

thanks. 

When you say use DirectQuery, do you mean with Enterprise Gateway - if we move our data to SQL Server ?

Thanks so much

[Greg_Deckler · Accepted solution]

I mean this:

https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/

[Linus_Torvalds]

This youtube video worked for me: https://www.youtube.com/watch?v=AEVI3GWl9Io

Ridiculous that this work around is even necessary.

Here are the steps from the video
1. From Reports go to the View tab
2. Select Performance Analyzer
3. Start the Analysis and the click "Refresh Visuals" in the top right of the Performance Analyzer
4. From within the Performance Analyzer expand your table and click "copy query"
5. Create a new table (from the Data section) and paste the query you copied in step 4.
6. From here you will have to modify your table
    1. Delete the DEFINE keyword at the top.
    2. Find the TOPN statement and enter a really large number like 10000000000
    3. Replace the EVALUATE keyword at the bottom with RETURN
    4. Delete the ORDERBY at the end of the query
7. In the sidebar of Data click the three dots, copy the whole table, paste it into Excel then save the excel file as CSV

[kdelmotey]

ok, yes i understood that part - sorry, I meant if we decide to leave our data on premise

[greggyb · Accepted solution]

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.