Forum Discussion

kdelmotey's avatar
kdelmotey
Frequent Visitor
10 years ago
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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

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's avatar
kdelmotey
Frequent Visitor
10 years ago

thanks. 

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

Thanks so much

    • kdelmotey's avatar
      kdelmotey
      Frequent Visitor
      10 years ago

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

      • greggyb's avatar
        greggyb
        Resident Rockstar
        10 years ago

        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.

    • Linus_Torvalds's avatar
      Linus_Torvalds
      Regular Visitor
      3 years ago

      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