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,
in the August release I'm trying to import a Json file from Data Lake and performing the conversion step below:
= Json.Document(#"CustUserList json")
I receive the following error (same error also converting other files. All of them are perfectly valid Json files).
Unexpected error: Adding the specified count to the semaphore would cause it to exceed its maximum count. Details: Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> System.Threading.SemaphoreFullException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> System.Threading.SemaphoreFullException: Adding the specified count to the semaphore would cause it to exceed its maximum count. at System.Threading.Semaphore.Release(Int32 releaseCount) at System.Threading.Semaphore.Release() at Microsoft.Internal.EngineContext.Leave() at Microsoft.Mashup.Engine1.Library.Web.WebContentsBinaryValue.get_AsBytes() at Microsoft.Mashup.Engine1.Runtime.Library.Binary.BufferFunctionValue.TypedInvoke(Value value)
This is an issue of the August Release. Previous release worked fine.
Solved! Go to Solution.
Found a way to revert back to July PBI release here and now everything is working fine.
@v-shex-msft: Please file it as a bug to the product team.
There is also another bug in the August release with ADLS connector. PBI asks for an optional parameter in the ADLS connection window but if you leave it blank the PBI retruns an error and you cannot go further.
Moreover if you do not delete the null or [] parameters that PBI automatically adds in the M language in the ADLS connectionstring when you publish the pbix to the PBI service you receive an error when ADLS dataset refreshes.
Hi,
Got the exact same problem on the August build.
A workaround that worked for me is to execute a Text.FromBinary before the Json.Document:
Hope it helps...
Hi,
Got the exact same problem on the August build.
A workaround that worked for me is to execute a Text.FromBinary before the Json.Document:
Hope it helps...
Hi @Anonymous,
I think this issue is more related to azure data lake json data amount limitation.
For this scenario, I'd like to suggest you to write a custom extractor instead to load data with original json array schema, it should more suitable with huge amount of data.
How do I load Large JSON Array files into Azure Data Lake Analytics (ADLA)
Regards,
Xiaoxin Sheng
Hi @v-shex-msft,
this is not the case. The file is only 2.8KB.
Consider the following 2 things:
1 if I open with PBI from local file system it works correctly
2 everything was functioning right in the July version of PBI, looks like an issue introduced with August version.
Is there a way to rollback the installation of PBI to July version?
Regards
Stefano
Found a way to revert back to July PBI release here and now everything is working fine.
@v-shex-msft: Please file it as a bug to the product team.
There is also another bug in the August release with ADLS connector. PBI asks for an optional parameter in the ADLS connection window but if you leave it blank the PBI retruns an error and you cannot go further.
Moreover if you do not delete the null or [] parameters that PBI automatically adds in the M language in the ADLS connectionstring when you publish the pbix to the PBI service you receive an error when ADLS dataset refreshes.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |