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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AndyTrezise
Helper II
Helper II

Unsupported data source in schedule refresh

Hi all...I am using a dynamic function to define and retrieve a site url (sharepoint list) to arrive at my data source.

 

Each row in my table refers to a sharepoint site so I first need to determine the site name and then read additional data from it to include in my table.

 

The root of the string is static and so is the list name but the actual URL differs depending on a specific parameter.

 

My function looks like this...

 

let LoadIssues = (SiteURL as text) =>

let
    Source = OData.Feed(SiteURL&"/_api/Web/Lists/getByTitle('Project%20Status%20List')/Items()?" )
in
    Source

in LoadIssues

I then invoke the query by adding a new column into my base table via 'invoke custom function'

 

 

I can then 'Expand' this column to see the fields from the list.

 

This all works perfectly in Desktop mode...bus as soon as I publish this to the web I am unable to refresh the data for the report, despite the face that it is drawing data from a data source (Sharepoint) that I have full permisions to access.

 

I just get the message "Unsupported data source in schedule refresh".

 

I this possible??? I can't find any answers online.

 

Thanks

2 REPLIES 2
v-danhe-msft
Employee
Employee

Hi @AndyTrezise,

Based on my research, it is a know issue, please wait for the fix.https://powerbi.microsoft.com/en-us/support/

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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