text: Skip to main contentğŸ¦œï¸�ğŸ”— LangChainDocsUse casesIntegrationsAPILangSmithJS/TS DocsCTRLKIntegrationsCallbacksChat modelsDocument loadersDocument transformersLLMsMemoryRetrieversText embedding modelsAgent toolkitsAmadeus ToolkitAzure Cognitive Services ToolkitCSV AgentDocument ComparisonGitHubGmail ToolkitJiraJSON AgentMultion ToolkitOffice365 ToolkitOpenAPI agentsNatural Language APIsPandas Dataframe AgentPlayWright Browser ToolkitPowerBI Dataset AgentPython AgentSpark Dataframe AgentSpark SQL AgentSQL Database AgentVectorstore AgentXorbits AgentToolsVector storesGrouped by providerIntegrationsAgent toolkitsPowerBI Dataset AgentOn this pagePowerBI Dataset AgentThis notebook showcases an agent designed to interact with a Power BI Dataset. The agent is designed to answer more general questions about a dataset, as well as recover from errors.Note that, as this agent is in active development, all answers might not be correct. It runs against the executequery endpoint, which does not allow deletes.Some notesâ€‹It relies on authentication with the azure.identity package, which can be installed with pip install azure-identity. Alternatively you can create the powerbi dataset with a token as a string without supplying the credentials.You can also supply a username to impersonate for use with datasets that have RLS enabled. The toolkit uses a LLM to create the query from the question, the agent uses the LLM for the overall execution.Testing was done mostly with a text-davinci-003 model, codex models did not seem to perform ver well.Initializationâ€‹from langchain.agents.agent_toolkits import create_pbi_agentfrom langchain.agents.agent_toolkits import PowerBIToolkitfrom langchain.utilities.powerbi import PowerBIDatasetfrom langchain.chat_models import ChatOpenAIfrom langchain.agents import AgentExecutorfrom azure.identity import DefaultAzureCredentialfast_llm = ChatOpenAI(