The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
14 | |
12 | |
3 | |
3 | |
2 |