Forum Discussion
PBi Service - Where Can I Access PBi Service Logs
I'm attempting to troubleshoot web api datasource issues with web.contents function; where can I access PBi Service logs to investigate possible cause of failed dataset refresh with web.contents function. Refresh history is reporting that refresh completed successfully but dataset table showing error. In the same dataset/datasource some tables refrresh and return data while some tables display error. Dataset refresh works fine in PBi Desktop however. Please note II have also parameterized the web.contents function to negate any problems in that regard..
Hi rtpg675411
If a refresh fails you can use the API to view the error message. The error message you get from the API below is the same error you see in the Power BI Service.
Datasets - Get Refresh Execution Details - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Thanks I'll try it....I've narrowed down my issue to the parallel query loading in PBi service. I'm a newbie to PBi. In a nutshell my dataset is based on dynamic Web API data requests. I've parameterized Web.Contents function and that works fine. Issue is in PBi desktop I've disabled parallel query loading so 1 query loaded at a time as some queries are dependent on other queries. PBi service does not seem to support single query loading as in PBi Desktop. I've tried Function.InvokeAfter and incorporating other dependencies attempt to achieve the same effect nothing working.
2 Replies
Hi rtpg675411
If a refresh fails you can use the API to view the error message. The error message you get from the API below is the same error you see in the Power BI Service.
Datasets - Get Refresh Execution Details - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Thanks I'll try it....I've narrowed down my issue to the parallel query loading in PBi service. I'm a newbie to PBi. In a nutshell my dataset is based on dynamic Web API data requests. I've parameterized Web.Contents function and that works fine. Issue is in PBi desktop I've disabled parallel query loading so 1 query loaded at a time as some queries are dependent on other queries. PBi service does not seem to support single query loading as in PBi Desktop. I've tried Function.InvokeAfter and incorporating other dependencies attempt to achieve the same effect nothing working.