Skip to content
TheChatArchiveThe Chat Archive
MiniMaxminimax-m1· MiniMaxHugging Face LMArena Human Preference 140K

I've been trying to configure PBI dataflow in PBI service. Dataflow should be connected…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with DeepSeekdeepseek-v3-0324’s answer.
  1. User

    I've been trying to configure PBI dataflow in PBI service. Dataflow should be connected to Oracle database. Please recommend me how to configure it.

  2. MiniMax Assistant

    To configure a Power BI Dataflow connected to an Oracle database, follow these steps:


    Prerequisites

    1. Oracle Client Software

      • Install the 64-bit Oracle Data Provider for .NET (ODP.NET) on the machine where the Power BI Gateway is installed (if connecting to an on-premises Oracle DB).
      • Ensure the Oracle client version is compatible with your Oracle server (e.g., Oracle 11g/12c/19c).
      • Download from Oracle's website.
    2. Connection Details

      • Server Name: Use the TNS name (e.g., ORCL) or EZ Connect format:
        hostname:port/service_name (e.g., mydb.example.com:1521/ORCL).
      • Credentials: Username and password with read access to the Oracle schema.
    3. On-Premises Gateway (If Oracle is On-Prem)


    Step-by-Step Configuration in Power BI Service

    1. Create a New Dataflow

      • Go to Power BI Service.
      • Navigate to Workspaces → Create → Dataflow.
      • Select Add new entities to start the setup.
    2. Choose Oracle as the Data Source

      • In the dataflow editor, click Add data → Oracle Database.
      • Enter connection details:
        • Server: TNS name or EZ Connect string (e.g., mydb.example.com:1521/ORCL).
        • Connection path: Optional (leave blank if not using TNS).
        • Authentication method: Basic (username/password).
        • Enter credentials (check "Store" for future use).
      • Click Next.
    3. Select Tables/Views or Write a Custom Query

      • Choose tables/views from the Oracle schema or write a custom SQL query.
      • Use Advanced Editor (if needed) to modify the Power Query M code.
    4. Configure Gateway (If Oracle is On-Prem)

      • In the dataflow editor, go to Settings → Gateway connection.
      • Select the gateway registered in your workspace.
      • Ensure the gateway machine has the Oracle client installed.
    5. Set Refresh Schedule

      • Navigate to Settings → Scheduled refresh.
      • Configure refresh frequency (e.g., daily/weekly).
      • Ensure credentials are stored securely.

    Troubleshooting Tips

    • Connection Errors:
      • Verify the TNS name or EZ Connect string is correct.
      • Check firewall rules to allow traffic from the gateway machine to the Oracle server (port 1521).
      • Test connectivity using Power BI Desktop first (File → Get Data → Oracle → Enter details).
    • Driver Issues:
      • Reinstall ODP.NET if you see "Oracle client not found" errors.
      • Ensure the Oracle client version matches the server architecture (64-bit).
    • Permissions:
      • Ensure the Oracle user has SELECT access to the tables/views.

    Example Connection String (EZ Connect Format)

    mydb.example.com:1521/ORCL
    

    Replace mydb.example.com, 1521, and ORCL with your server’s hostname, port, and service name.


    By following these steps, your Power BI Dataflow will connect to the Oracle database. Let me know if you encounter specific errors!

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.