Passing OData Source to Power query within Data Flow

Question

HI, 

I want to connect to Sharepoint Online Folder using Power Query in SSIS Data Flow. As I can not do that because of data connection problems in Power Query, I'm trying to use OData Source before Power Query, and then pass table gathered by OData Source to Power Query as Input table. PRoblem is I do not know how to pass OData Source Output table to Power Query input table.

Thanks for any help

Answer 1

Hi Tomislav1975,

As I can not do that because of data connection problems in Power Query

Could you please share the error messages in detail?

May I know if you can share the components in your ssis data flow task?

Please refer to Power Query Source and OData Source.

Best Regards,

Mona

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 2

Hi Tomislav1975,

May I know if you have anything to update?

If my response is useful to you , please remember to mark it as answer. Thank you.

Best Regards,

Mona

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 3

Solution to my question is described at https://www.youtube.com/watch?v=ufiux4_SCo8