cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JD2 Occasional Visitor
Occasional Visitor

Re: How to configure On-premises Gateway to SharePoint Folder source

I am running into a similar issue. I have the Enterprise gatway setup on Azure VM. I am successfully able to add SQL DB and Azure Blob data source connections. But when I try to add conections to Sahepoint Folder, it thows me an error. Can you please let me know if any one has faced such issue and how did you resolve it.

 

 

ausan Frequent Visitor
Frequent Visitor

Re: How to configure On-premises Gateway to SharePoint Folder source

AmdiSilword Frequent Visitor
Frequent Visitor

Re: How to configure On-premises Gateway to SharePoint Folder source

I think this is what we are asking for.

This video Link: https://www.youtube.com/watch?v=cKzdDO2W5-Y&t=53s, Shows how to create a Working Group on Power BI Service. It's the new technique for Working Groups not associated with Groups created on Office 365.

 

The video shows first how to create a working Group.

Now it comes. Then it shows how to associate Group created on O365 Sharepoint with Power BI Service, New Working Group.

A group on Sharepoint have it's own email. Which automatic will be created when the Group is created on Sharepoint.

It's important that this email it's added to the new Working Group. 

Now the Office 365 Sharepomit Group is associated. 

With Planning update It will also opdate from files on Sharepoint.

In my own setup. It's also connected with Odata to Navision.

 

Earlier in this Subject Person: ausan have place a link: https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

I have done the same setup. 

Tried with and without. The Sync with sharepoint Goup work anyway.

I have also tried only with https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud., then it doesn't sync.

 

walkra Member
Member

Re: How to configure On-premises Gateway to SharePoint Folder source

Hi, How Are You. I have tried to do everything I read in different publications but I still have not been able to configure the update schedule. Our report is connected to data from Solman (SAP) and Sharepoint but for this I have had no way to work, and therefore, I can not update from Power BI Service (app.powerbi.com) but yes I can update manually from Power BI Desktop

My Power BI Service license (app.powerbi.com) is different from Sharepoint, but under "Data source credentials" I enter the license without any inconvenience. The only rare thing that every time I press "Edit Credentials" asks me to re-enter the Sharepoint license (maybe it is correct that this is so; I enter here every time I read a note on this topic because I no longer know that I do).

I have tried to do everything that I think is necessary, but since I do not understand much English there are some things that are beyond my understanding (I use translate.google a lot).

I attached some screen printing of how it is configured and a step-by-step when I enter "Edit Credentials".

I hope you can help me.

Thank you so much.ActualizarAutomaticamente.pngActualizarAutomaticamente2.pngActualizarAutomaticamente3.pngActualizarAutomaticamente4.pngActualizarAutomaticamente5.pngActualizarAutomaticamente6.png

J_K Regular Visitor
Regular Visitor

Re: How to configure On-premises Gateway to SharePoint Folder source

I had a similar problem and managed to create a workaround utilizing dataflows.  In my case the goal is to combine SSAS database with a Sharepoint Excel file into a single data set.  Here's what I did roughly:

1) For the Excel on Sharepoint, I created a dataflow to read the Excel.  No gateway is selected.

2) In Power Query (Desktop), I created a query for my SSAS database which is on premise (gateway required). Then I created another query where the source is my dataflow that I created in step 1.

3) I published my dataset/report

4) The refresh worked.

 

Another thing to note here is to make sure you have the most recent gateway installed.  This is because the dataflow feature is relativley new in Power BI Service and since you want to use the dataflow as a source in PowerBI you need to make sure you have the most recent gateway installed or at least the one that support connecting to a dataflow from Power Query Desktop.

walkra Member
Member

Re: How to configure On-premises Gateway to SharePoint Folder source

Hi, J_K, How Are You?.  

Thank You Very Much. Today I will try to carry out your advice. I don't remember that I used dataflows before (maybe I did it but I don't know the concept). I then tell him how I left.

Thank You Very Much,  again. 

 

Highlighted
alle_francisco New Member
New Member

Re: How to configure On-premises Gateway to SharePoint Folder source

Worked like a charm, thank you.

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,077)