Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pfarias
Helper I
Helper I

Encrypting the connection isn't supported for Data source kind: SharePoint

pfarias_0-1660434385095.png

I am in total distress, as I could not find the solution to this error.

My flow worked perfectly, until these days. It started having this problem yesterday and I can't get it to run without error unless it's connected to a gateway. I will not be able to use the gateway I tested, because the VM will not always be on.

 

The error happens in the step where a merge is made between two data sources: AZURE SQL SERVER and SHAREPOINT.

 

pfarias_2-1660434625179.png

 

 

8 REPLIES 8
pfarias
Helper I
Helper I

I still haven't been able to solve the problem. Any idea?

otravers
Community Champion
Community Champion

Have you tried using landing dataflows as I suggested? This can be done in a Pro workspace.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Yes, I tried. But when using this feature, dataflow informs you that it needs to have Premium capacity to do this process.

otravers
Community Champion
Community Champion

In the child dataflow:

 

1. Uncheck "Load" for the query fetching the landing dataflows ("Landing1" and "Landing2")

2. Create a new query by choosing "Reference" from the right click menu of the "Landing1" entity.

3. In that new query you can now Merge with Landing2. Because you're not loading the source dataflows, you're not using Linked Entities and you don't need Premium.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

pfarias_1-1661170964451.png

I tried and still the same error. In Power BI Desktop I can uncheck the encrypted connection flag. And in Dataflow, can I?

Answering my ask myself, no.
Power BI security white paper 

otravers
Community Champion
Community Champion

Try loading the SQL and Sharepoint in landing dataflows where you do nothing else, then merge these two dataflows in a third dataflow.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

I believe it should be resolve. But this project, only have the Pro license.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors