March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi ,
I have generated .pbix file using Power BI desktop application for Hive database (using odbc connection). I haveused PowerBI Embaded utility to deploy in Azure. It's deployed successfully and able to see result in web App.
When i tried to update the connection string using option 7. It's throwing bellow error. Can any one help me to solve this.
--------------------------------------------------
Expected one datasource, updating the firstOoops, something broke: System.Argume
ntOutOfRangeException: Index was out of range. Must be non-negative and less tha
n the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argu
ment, ExceptionResource resource)
at System.Collections.Generic.List`1.get_Item(Int32 index)
at ProvisionSample.Program.<UpdateConnection>d__27.MoveNext() in D:\Azure\POC
s\Power BI\power-bi-embedded-integrate-report-into-web-app-master\ProvisionSampl
e\Program.cs:line 624
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNot
ification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
at ProvisionSample.Program.<Run>d__17.MoveNext() in D:\Azure\POCs\Power BI\po
wer-bi-embedded-integrate-report-into-web-app-master\ProvisionSample\Program.cs:
line 239
--------------------------------------------------
Thanks & regards
Sai baba
Solved! Go to Solution.
Power BI Embedded so far only supports direct query to Azure SQL DB and Azure SQL DW. And based on my test, the option 7 works to update the connection string to an Azure SQL DB.
I don't exactly clear about your scenario, however you mentioned ODBC, I guess that is the reason cause the error. You can check this idea Support other data sources Direct Query using Gateway on Embedded Power BI and vote it up.
Hi ,
I have generated .pbix file using Power BI desktop application for Hive database (using odbc connection). I haveused PowerBI Embaded utility to deploy in Azure. It's deployed successfully and able to see result in web App.
When i tried to update the connection string using option 7. It's throwing bellow error. Can any one help me to solve this.
--------------------------------------------------
Expected one datasource, updating the firstOoops, something broke: System.Argume
ntOutOfRangeException: Index was out of range. Must be non-negative and less tha
n the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argu
ment, ExceptionResource resource)
at System.Collections.Generic.List`1.get_Item(Int32 index)
at ProvisionSample.Program.<UpdateConnection>d__27.MoveNext() in D:\Azure\POC
s\Power BI\power-bi-embedded-integrate-report-into-web-app-master\ProvisionSampl
e\Program.cs:line 624
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNot
ification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
at ProvisionSample.Program.<Run>d__17.MoveNext() in D:\Azure\POCs\Power BI\po
wer-bi-embedded-integrate-report-into-web-app-master\ProvisionSample\Program.cs:
line 239
--------------------------------------------------
Thanks & regards
Sai baba
Hi Sai,
I am trying to connect powerBI with Hive. I have a connection string. Can you please help me with how I can do it?
Did you use any specific driver?
In a few days we will be moving to Azure cloud and I also want to know if you were successfully able to do it.
Thanks in advance
Power BI Embedded so far only supports direct query to Azure SQL DB and Azure SQL DW. And based on my test, the option 7 works to update the connection string to an Azure SQL DB.
I don't exactly clear about your scenario, however you mentioned ODBC, I guess that is the reason cause the error. You can check this idea Support other data sources Direct Query using Gateway on Embedded Power BI and vote it up.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
7 | |
3 | |
2 | |
1 | |
1 |
User | Count |
---|---|
8 | |
3 | |
2 | |
2 | |
2 |