Create a custom connector to azure blob storage from power query sdk

[jaryszek]

Hello,

it is possible to create a custom connector to cloud storage like blob storage using power query SDK ?

how to make this?

Best wishes,
Jacek

[v-ssriganesh]

Hello @jaryszek,
Thank you for posting your query in Microsoft fabric community forum.

yes, it is possible to create a custom connector using power query SDK. To implement the process please refer the below documentation:
Develop a connector using the Power Query SDK - Power Query | Microsoft Learn

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.

[jaryszek]

Thanks. 

But can I build the connector to cloud storage?

[v-ssriganesh · Accepted solution]

Hello @jaryszek,

Yes, you can build a connector to cloud storage using Microsoft Fabric. Data Factory in Microsoft Fabric offers a rich set of connectors that allow you to connect to different types of data stores, including cloud storage. You can use these connectors to transform data in dataflows or move large datasets in a data pipeline.
For reference ​Connector overview - Microsoft Fabric | Microsoft Learn

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.

[lbendlin]

Out of curiosity - What prevents you from using the default connector?

[jaryszek]

Thanks! 

I want to have full software engineering path, so first test power queries using power query SDK, next export it as mez file and import into power bi. 

How in other way programmatically interact with power queries? 

Best Wishes,
Jacek

[lbendlin]

You can run Power Queries in a myriad of ways. At the end of the day they are partition definitions.  Use the standard processes to create, refresh and consume partitions.

Or use Power Automate 🙂

Chris Webb's BI Blog: Using Power Query And Microsoft Flow To Automate The Creation Of CSV Files 

[jaryszek]

thanks, 

what are partition definitions of power queries?

Best,
Jacek