Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We are using the API to programatically upload a file. Everything was going well until we tried to upload a 1.2gb file.
I found from the community that you can supply us with a direct URL to our local PowerBI workspace cluster. See below:
For anyone with same issue, the problem is in using the base url https://api.powerbi.com. As per Microsoft support, when using this base url and importing large PBIX files, it has a tendency to timeout the file stream, thus throwing the exception. Microsoft support provided a direct URL to our local Power Bi Workspace cluster and the issue was resolved.
We are using the EASTUS location.
Than you in advance
Hi @bsushy,
Absolutely. When the workspace collections are created with the Azure dashboard, there is a choice of location to select (i.e. East US 2, West US 1, etc.). These are their clusters for Power BI workspace collections and they have direct API URLs to these clusters so instead of https://api.powerbi.com, one would use the direct URL to the Azure cluster location where your workspace collections are hosted. For my case scenario, we have all of our workspace collections hosted in the same cluster location so I just had to use the direct URL instead of https://api.powerbi.com and the filestream timeouts (including the vague Internal Server Error exception returned by the PostImportWithFile method) were gone. Just check with your Microsoft support rep for your Power BI cluster's direct URL if you have to import larger PBIX files.
As suggested by @albin-ipmg in this similar thread, you may need to create a support ticket on Power BI Support page for better assistance on this issue.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |