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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
MelStaunton
Helper III
Helper III

Internal server error after successful connection to Sharepoint

Hi all,

 

I am working off this detailed guide :

https://powerbi.microsoft.com/de-de/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

 

I am creating a dataflow accessing a SHarepoint site, trying to combine multiple Excel files.

 

1. I can successfully established a connection to my Sharepoint site

2. I can see the details of same site

3. I can filter for the folder containing my files

4. I get internal server error message. Where am I going wrong?

 

I can access those same Excel files just fine from within a .pbix. But since multiple datasources are getting combined, each of which gets refreshed at different intervals, having separate dataflows seems to be the way to go....

 

As always, any help is appreciated!

 

Thanks,

Melanie

 

Step 1Step 1Step2Step2Step 3Step 3

1 ACCEPTED SOLUTION

After opening a support ticket with MS for Sharepoint, this has been solved rather simply:

 

I need to be an owner of the Sharepoint site.

 

While I was having issues I was just a member of the Sharepoint site, members have Edit rights which was enough to get the same files from within Power BI Desktop. Apparently that is not enough to create a dataflow in the service. I needed to be an owner.

 

 

View solution in original post

8 REPLIES 8
rafalmiszewski
Regular Visitor

Hi,

 

Please ensure you have API parameter added:

SharePoint.Files("https://tenant.sharepoint.com/teams/sSite/"[ApiVersion = 15]).
 
I added it and it works.
 
Rafal

The Api was added. Still only worked after being a owner.

Icey
Community Support
Community Support

Hi @MelStaunton ,

 

Is this problem solved?

 

Best Regards,

Icey

NO. Still open ticket with MS

After opening a support ticket with MS for Sharepoint, this has been solved rather simply:

 

I need to be an owner of the Sharepoint site.

 

While I was having issues I was just a member of the Sharepoint site, members have Edit rights which was enough to get the same files from within Power BI Desktop. Apparently that is not enough to create a dataflow in the service. I needed to be an owner.

 

 

Icey
Community Support
Community Support

Hi @MelStaunton ,

I have tested and it works well on my side.

sharepoint.PNG

 

Please clear browser cache and try it again.

If the issue is still there and you are a pro user, I suggest you to create a support ticket to get further help.

 

Support Ticket.gif

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

GilbertQ
Super User
Super User

Hi there

The error 500 looks like it cannot find the file.

What happens if you try and locate that file on SharePoint to make sure it is there?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

The files are there.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors