Forum Discussion
Power BI Embedded - can't upload PBIX to workspace
There are numerous ways to accomplish this, but if you are having issues with file size or upload speed this technique always works for me. My numerous PowerBI files all average over 400 MB, which should not be a problem but most upload speeds are throttled such that importing them into a workspace ID is problematic. When the upload does work, it typically takes over 25 minutes. This technique takes about one.
This assumes you have access to a fileshare in portal.azure.com and have uploaded your pbix file there.
Launch Cloud Shell by clicking on this button.
Note: If this is your first time launching Cloud Shell you'll have to provision a persistent file share for it. Read this to understand the pricing and process. It's really cheap.
Navigate to the location where you have uploaded your pbix. Just use simple dir and cd commands.
The ConnectionString will be used to mount that fileshare as a drive in Cloud Shell.
Mount the fileshare as a drive.
The syntax follows this layout:
net use <DesiredDriveLetter>: \\<MyStorageAccountName>.file.core.windows.net\<MyFileShareName> <AccountKey> /user:Azure\<MyStorageAccountName>
Access the file and load it into a workspace. The easiest way 've found to do this is using the PowerBI-Cli found here.
PowerBI-Cli is now deprecated however, it is a very useful tool that I'll continue to use until something better comes along.
You will have to load the powerbi commands using npm.
npm install powerbi-cli -g
Using the following syntax, you can load your pbix file into a workspace. Even the largest files take about a minute.
powerbi import -c <collection> -w <workspaceId> -k <accessKey> -f <file> -n [name] -o [overwrite]
Hope this helps!
Greg