Forum Discussion
Isssue Adding Web.Content Column to Web Data
Other things I have tried:
- I tried separating the queries into 2, as per this article (https://excelguru.ca/power-query-errors-please-rebuild-this-data-combination/), but to no avail
- I tried making one large PowerQuery that does everything: loads the external file, calls the API for the Access Token, and calls the API for the tracking data, but that also failed
- I tried disabling other settings per this posting (https://community.fabric.microsoft.com/t5/Desktop/Query-references-other-queries-or-steps-so-it-may-not-directly/m-p/2635583#M925998), but that didn't work either.
- Tried setting both data sources to Skip Test Connection on the Power BI Service settings, but that didn't solve anything either.
So far, nothing has worked. 😭
Hi directvman67 ,
Thanks for reaching out to the Microsoft fabric community forum.
Thanks for trying all those steps and sharing the results. Since the query works in Desktop but fails only in the Power BI Service, and the usual privacy/connector workarounds didn’t resolve it, the next best step would be to open a Microsoft support ticket so the engineering team can check what’s happening on the backend.
Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Best Regards,
Community Support Team
Thank you. I did open a support ticket: TrackingID#2511100010001281. I have sent the Support Professional from Microsoft Power BI support team several messages and I am awaiting a response.
Hi directvman67 ,
Since you've already submitted the ticket, the support team will handle the issue and resolve it soon. They will get back to you.
Thank you