Forum Discussion

prasaddn's avatar
prasaddn
Frequent Visitor
8 months ago
Solved

Python Visual rendering issue on .Net wrapper

I have a power bi dashboard that is hosted in a wrapper portal built on .net or some technology. So that dashboard can be accessed only authorized users.   The dashboard is about some surveys. I h...
Need Help
  • kushanNa's avatar
    kushanNa
    7 months ago

    Hi prasaddn 

     

    Please check the attached sample to see if it provides any insights to do it with DAX.

     

     

kushanNa's avatar
kushanNa
Super User
7 months ago

Hi prasaddn  

 

Apologies for misreading your original post and by going through other replies you had made. I believe that I understand your situation now, so I’ve deleted my previous comment.

 

If I understand correctly, you’re basically looking for an alternative solution for python to use an API as a data source that works like DirectQuery. If that’s the case, please have a look at this article:

 

https://blog.crossjoin.co.uk/2021/04/25/can-i-build-a-power-bi-directquery-dataset-on-top-of-a-rest-api/

 

prasaddn's avatar
prasaddn
Frequent Visitor
7 months ago

Hi kushanNa In my other reply I have posted my Python Script which works as expected. However, it wont support when the dashboard is hosted / embedded on .NET wrapper.  Hence, I am looking for alternate ways to summarize the survey comments, like some custom visual or script that supports in .NET wrapper.   

  • kushanNa's avatar
    kushanNa
    Super User
    7 months ago

    Hi  prasaddn 

     

    To be honest, since I am not an app or web developer, I am not very familiar with .NET wrappers.

     

    However, I can suggest a solution for you to try if it suites you. Power BI Embedded Analytics can detect slicer selections.

     

    I did a test and I have written the following blog to demonstrate how you can capture slicer selections using Power BI Embedded Analytics with HTML and Javascript;
    https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Real-Time-Cross-Report-Filtering-Using-JavaScript-embedded/ba-p/4850521

     

    Once you capture the slicer selections-> you can send them to your summarization logic using an API->store them in a data source where DirectQuery is enabled, and then pull that data into your visual.