Forum Discussion

Pinky0404's avatar
Pinky0404
Icon for Helper III rankHelper III
8 years ago

File is too large to Publish

Hi All,   I  have a Power BI file that gets data from sharepoint online and has exceeded 1GB. Can Someone please help me with alternative  ideas  and a brief explanation inorder to publish the repo...
Need Help
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Well, your options are generally if you can do Direct Query or go with Power BI Premium. If you can't do either of those, you will probably need to find a way to export the data into a SQL Server perhaps and then use Direct Query.

  • Pinky0404's avatar
    Pinky0404
    Icon for Helper III rankHelper III
    8 years ago

    Thanks for your response. Are there any tutorials on how to use Direct Query?

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      8 years ago

      It's just an option when you connect to the data source. Either the data connection will support it or it will not.