Forum Discussion

itsmebvk's avatar
itsmebvk
Continued Contributor
3 years ago
Solved

Power BI Admin API Report Refresh Issues

 

Hi Experts,

 

I am trying to create an Power BI audit report as suggested some of the blogs mentioned below. Everything seems to be working in my desktop version, when I publish this report powerbi service (premium workspace)  and try to refresh it, i started getting following error

 

 

Data source error:	Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface.
Cluster URI:	WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:	XXXXXXXX-84e6-f2e703dd4c82
Request ID:	XXXXXXX-dc504d57c852
Time:	2023-05-04 06:17:19Z

 

https://bielite.com/blog/building-a-power-bi-admin-report/ 

 

https://www.youtube.com/watch?v=cTqFNg_y9lw&list=PLL-WSn9hvefogtxxi7CJhjLCJvrDY0mpQ

 

 

When I try to configure credentials I am getting above error, however one of the datasource credentials I was able to setup. But rest two are throwing errors. But it was working without any issues in Power Bi Desktop.  I tried all types of "Authentication Method" but no luck . 😞 . can you please provide any suggestions  or provide any inputs aroudn this issue.

 

1. Working

 

 

 

2. Not working

 

 

 

3.Not working

 

 

 

Thanks in advance.

Need Help
  • itsmebvk's avatar
    itsmebvk
    3 years ago

    ibarrau apologies for the late reply. I was able to resolve this issue by adjusting all privacy level settings to organizational and skip the test connection to the soource which was not allowing .

     

    Appreciate for your time and inputs.

6 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    3 years ago

    Hi. I'm not totally sure that the code would work, but what you can do is be sure to use the same privacy level for all the credentials sources (like organizational or public) and skip test connections. There are some API sources that can't pass the test but will work any way. If there is a real issue it will show when refreshing.

    I hope that helps,

    • itsmebvk's avatar
      itsmebvk
      Continued Contributor
      3 years ago

      ibarrau Thanks for your inputs. Yes I have already tried that method. But no luck 😞 

      • ibarrau's avatar
        ibarrau
        Super User
        3 years ago

        Then I think the Power Query code of the post it's an approach. Not every develop at Desktop can be on the production environment. What we actually do for activity logs is exporting with a Python library SimplePBI. Then connect PowerBi to that data. 

        If you have a requirement for doing it over power query then it might be deep dive research on how to create a code that works on service. Otherwise you can try approaches like python.

        I hope that helps,