Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Ive managed to create a report that runs from an API online, it is a ticketing system called fresh desk - Power BI is just making the data more manageable and visually clear.
Anyway - the problem I have is that I can refresh within the desktop but when I upload to the PBI Service I cant refresh. Ive read up a lot on this and things to do with dynamic data sources ect. However I have also seen someone manage to do this by making the url a text string first and then manually create the table.
Can someone look at my code and decide whether it is possible for me? I don't have much knowledge of this area.
Thank you,
Jack
(Page as number)=>
let
Source = Json.Document(Web.Contents("https://middlesexgroup.freshdesk.com/api/v2/tickets?updated_since=2010-01-01T02:00:00Z&include=requester&include=description&page="&Number.ToText(Page))),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"cc_emails", "fwd_emails", "reply_cc_emails", "ticket_cc_emails", "fr_escalated", "spam", "email_config_id", "group_id", "priority", "requester_id", "responder_id", "source", "company_id", "status", "subject", "association_type", "support_email", "to_emails", "product_id", "id", "type", "due_by", "fr_due_by", "is_escalated", "custom_fields", "created_at", "updated_at", "associated_tickets_count", "tags", "description", "description_text"}, {"cc_emails", "fwd_emails", "reply_cc_emails", "ticket_cc_emails", "fr_escalated", "spam", "email_config_id", "group_id", "priority", "requester_id", "responder_id", "source", "company_id", "status", "subject", "association_type", "support_email", "to_emails", "product_id", "id", "type", "due_by", "fr_due_by", "is_escalated", "custom_fields", "created_at", "updated_at", "associated_tickets_count", "tags", "description", "description_text"}),
#"Expanded custom_fields" = Table.ExpandRecordColumn(#"Expanded Column1", "custom_fields", {"issue_type", "machinearea", "group"}, {"custom_fields.issue_type", "custom_fields.machinearea", "custom_fields.group"}),
#"Split Column" = Table.SplitColumn(#"Expanded custom_fields", "tags", each _, {"tags.0"})
in
#"Split Column"
Solved! Go to Solution.
Hi @Jackbaz99,
You can take a look at the following blog and try to add relativepath and query options to your connector if they help for your scenario:
Regards,
Xiaoxin Sheng
Hi @Jackbaz99,
You can take a look at the following blog and try to add relativepath and query options to your connector if they help for your scenario:
Regards,
Xiaoxin Sheng
@Jackbaz99 , what is the issue it is giving it on power bi service? Have updated datasource details under the data source setting and they are not working?
Hi @amitchandak the error when on the PBI service is
You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Discover Data SourcesThank you
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |