help.
2 Topics
Scheduled Refresh Errors with the Dates
Hi Everyone, I have a Fact table with some sales data and a date column and a separate date Table created in DAX with the CALENDARAUTO(). The tables are linked together in the data model by the dates and They are used to generate a visual displaying sales trends over the years. On the line graph visual i tried using the dates from the Facts table as well as the dates from the Dates table. Same case when it comes to the filters (I use a date timeline) and both approaches seem to work fine on the desktop power bi. The problem comes when i publish the report to trhe report sever which has a scheduled refresh running every day. After each refresh , if i use the date table dates on the visual and the Fact table dates on the timeline filter, the visual become blank for some reason, if i use the fact table dates on the graphs and the the Dates table dates on the filter, all the values get grouped to the first date only (When i move the timeline to later dates it shows blank). I could use the Facts tables dates on both ends but i need to be able to drill down on the report visuals and this becomes not possible with this approach. Any idea what this may be caused by and the solutions? Thank you.Solved1.9KViews0likes6Comments
Help Trying to use RelativePath to update published Power BI Report.
Hello, I have a published Power BI report that pulls data from a Web/API. Following all kinds of help videos I set it up get paginated results from the API by creating a page function and then a List.Generate code (see below). However I just found out that my published report will not schedule update because it is pulling from an API/web. I need to figure out how to get this report to update/schedule refresh. From what I have read, this would require changing my orginal function (below) to use something called RelativePath, which I don't fully understand. I followed the instructions I read, but the updated function (also, below) when ran with the list.generate started creating new functions and got stuck trying to pull from the API. Something is wrong. Could someone help me rewrite this to properly use relativepath so I can update my awesome published report? List Generate (for paginated results) = List.Generate(()=> [Result = try fCustomers(1) otherwise null, Page=1], each [Result]<>null, each [Result = try fCustomers([Page]+1) otherwise null, Page=[Page]+1], each [Result]) Original Function = (Page as number)=> let Source = Json.Document(Web.Contents("https://api.vhx.tv/customers/?page="&Number.ToText(Page))), _embedded = Source[_embedded], customers = _embedded[customers] in customers RelativePath Function = (Page as number)=> let Source = Json.Document(Web.Contents("https://api.vhx.tv/customers/", [RelativePath="?", Query= [ Page="?&Number.ToText(Page)"]])), _embedded = Source[_embedded], customers = _embedded[customers] in customersSolved656Views0likes2Comments