langchain icon indicating copy to clipboard operation
langchain copied to clipboard

Support for a PowerBI agent and toolkit

Open eavanvalkenburg opened this issue 1 year ago • 6 comments

Initial version of support to have a bot talk to powerbi, docs still to be added.

eavanvalkenburg avatar Apr 06 '23 13:04 eavanvalkenburg

Mostly some notes on best practices and on authentication, for in the notebook and I do want to test with a more complex dataset, plan to do that early next week, this might cause some prompt changes, especially for the query checker. I noticed at times that that just gives back the same thing each time and then it doesn't make sense to keep running those queries, so that should be improved.

But, overall it seems to work well already!

eavanvalkenburg avatar Apr 06 '23 19:04 eavanvalkenburg

Mostly some notes on best practices and on authentication, for in the notebook and I do want to test with a more complex dataset, plan to do that early next week, this might cause some prompt changes, especially for the query checker. I noticed at times that that just gives back the same thing each time and then it doesn't make sense to keep running those queries, so that should be improved.

But, overall it seems to work well already!

cool! should i hold off on landing until early next week then?

hwchase17 avatar Apr 06 '23 20:04 hwchase17

Just also added some refinement, but give me till next week to finish.

eavanvalkenburg avatar Apr 07 '23 12:04 eavanvalkenburg

Just also added some refinement, but give me till next week to finish.

sounds great!

hwchase17 avatar Apr 11 '23 04:04 hwchase17

@hwchase17 this is now good to go, also includes async support and I've split the few-shot examples out so that you can supply your own which makes the recognition much better! Still getting some weird pydantic error that I can't figure out, maybe you know more!

eavanvalkenburg avatar Apr 13 '23 15:04 eavanvalkenburg

apparently pydantic didn't like new style typing with future.annotations, after reverting it works now!

eavanvalkenburg avatar Apr 14 '23 08:04 eavanvalkenburg

gonna try to fix and merge in!

hwchase17 avatar Apr 20 '23 04:04 hwchase17

@eavanvalkenburg Hello, when I run example code, it shows this. Do you know how to solve this?

Traceback (most recent call last): File ".py", line 20, in powerbi=PowerBIDataset(None, "b0c0d9dc-726e-4bf5-8344-e6cc807c4a75", ['tableName'], DefaultAzureCredential()), File "pydantic\main.py", line 332, in pydantic.main.BaseModel.init TypeError: init() takes exactly 1 positional argument (5 given)

poweihuang0817 avatar Apr 24 '23 04:04 poweihuang0817

fixed in #3426

eavanvalkenburg avatar Apr 24 '23 08:04 eavanvalkenburg