Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I connect to sharepoint list online, I used below fuction to get data along with version history from sharepoint... Im unable to do schedule refresh as it is dynamic data source... Im unaware of how set relative path and query
Please Help Me to set schedule refresh.. This is for my project
let
Source = (VersionsRelevantSharePointListName as text, VersionsRelevantSharePointLocation as text, VersionsRelevantItemID as number) => let
Source = Xml.Tables(Web.Contents(Text.Combine({
VersionsRelevantSharePointLocation,
"/_api/web/Lists/getbytitle('",
VersionsRelevantSharePointListName ,
"')/items(",
Text.From(VersionsRelevantItemID),
")/versions"}
))),
entry = Source{0}[entry],
#"Removed Other Columns2" = Table.SelectColumns(entry,{"content"}),
#"Expanded content" = Table.ExpandTableColumn(#"Removed Other Columns2", "content", {"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"}, {"content"}),
#"Expanded content1" = Table.ExpandTableColumn(#"Expanded content", "content", {"properties"}, {"properties"}),
#"Expanded properties" = Table.ExpandTableColumn(#"Expanded content1", "properties", {"http://schemas.microsoft.com/ado/2007/08/dataservices"}, {"properties"})
in
#"Expanded properties"
in
Source
Solved! Go to Solution.
Hi, @Anonymous
This needs to manually modify the data source in the service.
Change data source with parameters:
How to Parameterize Data Sources in Power BI | Tessellation (tessellationtech.io)
These methods can automatically modify the data source, but need to be customized according to requirements.
I don't know what part of the changed path is, you may need to customize a rule, e.g. according to time.
Like this:
Solved: Re: 2 Parameters - Microsoft Power BI Community
Solved: Dynamic Excel name handling in Power BI - Microsoft Power BI Community
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Im Sorry, If i said someting wrong, In order to do schedule refresh on datasource connected to web contents we must set "Relative Path" and define parameters in query, correct me if im wrong.... I want help in doing it on above fuction, then my problem is solved ....
Hi, @Anonymous
This needs to manually modify the data source in the service.
Change data source with parameters:
How to Parameterize Data Sources in Power BI | Tessellation (tessellationtech.io)
These methods can automatically modify the data source, but need to be customized according to requirements.
I don't know what part of the changed path is, you may need to customize a rule, e.g. according to time.
Like this:
Solved: Re: 2 Parameters - Microsoft Power BI Community
Solved: Dynamic Excel name handling in Power BI - Microsoft Power BI Community
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
https://www.enjoysharepoint.com/power-bi-schedule-refresh/
Proud to be a Super User!
@Anonymous
This article helps you!
Proud to be a Super User!
Im trying to enable schedule refresh on web contents, as I connect to shar point it says, my data source is dynamic -Im passing parameters to get the data...
In code I need to set parameters as static ... this can be acheive by setting Relative path and query... I want help regarding how to set those and make above fuction enable for scheduling refresh. Than You
Hi, @Anonymous
I'm afraid not, how can a dynamic data source set static parameters?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |