microsoft / microsoft/Power-Fx

PowerFx Connector Table Integration Sample

Open
#2,435 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Needs Discussion
Dominant language
C#
Stars
3.4k
Forks
358
Avg merge
10h 34m
Merged PRs (30d)
3

Description

PowerFx is so awesome!!

Short line about my product, it helping users to manage their data.
I'm now trying to integrate PowerFx into my product, but having problem when trying to connect powerfx with sqlite.

As I see in documentation, PowerFx does support Table and helper functions like Filter, AddColumn, ShowColumns,...I wish my users can use these functions to interact with their database.

I have tried read PowerFx source like Connector, ConnectorTable, TabularService but look like they are just internal class only.

Can we have a sample host showing how to connect to a database like sqlite or sql server.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reading the Connector, ConnectorTable, and TabularService classes mentioned in the issue, along with any existing hosting samples and documentation. A complete contribution would provide a sample host demonstrating how Power Fx table functions such as Filter, AddColumn, and ShowColumns interact with a SQLite or SQL Server database.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql, sqlite
Domain
backend, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.