Power BI import file size limitations

[daive]

Hey guys,

Does anyone know how to import a pbix file larger than 350MB?

I am using the New-PowerBIReport command and getting the error "New-PowerBIReport : A task was canceled."

New-PowerBIReport -WorkspaceId $workspaceId -Path $pbixFilePath -Name $datasetName -Timeout 240

I've tried setting a higher timeout value, added the workspace to the premium capacity and changed the workspace to use the Large semantic model storage format but still failing.

PowerShell seems to have no trouble with a file 350MB or less. A 400MB file fails and the largest I have is around 920MB. 

I am able to upload the file directly into the workspace using the GUI but need to get this working in PowerShell as there are many workspaces\reports to import.

Is it possible to use PowerShell to import files just under 1GB or do I need to get the owner to publish the the dataset without any data - and then refresh the data from the data source?

Thanks,
David

[Anonymous]

Hi @daive 

Could you please confirm if the issue has been resolved? As mentioned earlier, did you raise a support ticket after encountering the problem? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

[Anonymous]

Hi @daive 
Thank you for reaching out microsoft fabric community forum.
It appears that you are experiencing an  issue related to Power BI's file size limitations. Here are a few suggestions to address this:

• If you're using Power BI Premium, you can enable incremental refresh for large datasets. This allows you to refresh only the data that has changed, rather than the entire dataset.
•  Ensure that your workspace is set to use the Large data storage format. This setting allows datasets to exceed the 1 GB limit, up to the available RAM of the capacity.
• Consider splitting your data into smaller chunks and publishing them separately. You can then combine them in Power BI Service.
•  If possible, use Direct Query instead of Import mode. This can help manage large datasets more efficiently.
  
  After trying the troubleshooting steps mentioned above, if the issue persists, I recommend raising a support ticket as suggested by @lbendlin.
  To create a support ticket for Fabric and Power BI, please follow the steps outlined in the guide:
  

  How to create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

  
  
  If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.
  
  

  Best regards,

[Anonymous]

Hi @daive 
Thank you for reaching out microsoft fabric community forum.
I wanted to check if you had the opportunity to review the information provided by @lbendlin . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[daive]

Hi @Anonymous ,

I am still looking for a solution to this. I have not yet logged a case as per @lbendlin suggestion

[daive]

Hi @lbendlin ,

I am assuming it is, here are some screenshots .

[lbendlin · Accepted solution]

That should give you a 10 GB upload limit PER PARTITION

What is Power BI Premium? - Power BI | Microsoft Learn

Since you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

[daive]

Thanks @lbendlin - I will give that a go

[lbendlin]

is this true Premium or PPU?