Skip to main content

Notifications

Topic Creation & Management
Unanswered

Get Power BI data and send in chat

Posted on by 10

Hey everyone, 

We have a nice dashboard in Power BI. I'd like to create a bot you where you can ask "Sales last month", and then it reports the "Sales last month" from the Power BI it's hooked up to. 

I'm having a hard time wrapping my head around if this is even possible? Any alternatives? 

Categories:
  • Re: Get Power BI data and send in chat

    Good day, 

    Could you please elaborate on the steps? Also what is meant by markdown format/image? 

    Also if you can give clarity on this step?

    Daliese_0-1646377601530.png

    I only have these options on the Flow Setup:

    Daliese_1-1646377696171.png

    Thank you

  • Expiscornovus Profile Picture
    Expiscornovus 1,667 on at
    Re: Get Power BI data and send in chat

    1. Initialize variable. Using that later for the markdown image link.

     

    onedriveurl.png

     

    2. This is part of the setup of the Export To File action. In this one you can configure a lot. And like mentioned earlier this action also depends on configuration and licensing on the Power BI side of things.

     

    exporttofile_powerbi.png

     

    3. Create file action. This creates a file on OneDrive with the File Content of the previous action.

     

    createfile_powerbi.png

     

    4. Returning the link of the created OneDrive file in markdown format to the agent. I am using expression where I concatenate the OneDrive variable with the Name of the Create file action.

     

    Which should be valid url for the chatbot to embed it as an image. I wrap it in a Image markdown tag ![Image](linktoimage)

     

    concat(variables('OneDriveUrl'), outputs('Create_file')?['body/Name'])

     

    concat_onedrivefile.png

  • EMIL_K_DIT Profile Picture
    EMIL_K_DIT 10 on at
    Re: Get Power BI data and send in chat

    Alright I’ve tried for 4+ hours now and it seems I’m not getting closer. 

    if you have the time would you mind sharing what you have under each specific flow in Power Automate? Compared to your skills in there I seem embarrassingly poor at it.

  • Expiscornovus Profile Picture
    Expiscornovus 1,667 on at
    Re: Get Power BI data and send in chat

    Hi @EMIL_K_DIT,

     

    Yes, I was talking about the Power BI pro license 🙂

  • EMIL_K_DIT Profile Picture
    EMIL_K_DIT 10 on at
    Re: Get Power BI data and send in chat

    @Expiscornovus thats a Power BI pro license right? 

    We do have that 😉 This is awesome! Thanks gonna go ahead and test. 

  • Expiscornovus Profile Picture
    Expiscornovus 1,667 on at
    Re: Get Power BI data and send in chat

    Hi @EMIL_K_DIT,


    One approach could be to use a flow to export the reports as an png and show it via markdown. But as far as I am aware that does require a pro licence. I don't know if you are allowed to use that feature in your Power BI workspace/environment?

     

    Below is an example of such an approach.

     

    Bot setup

     

    mylastmonthsalesreport.png

     

    Flow setup

     

    potentialapproach.png

  • EMIL_K_DIT Profile Picture
    EMIL_K_DIT 10 on at
    Re: Get Power BI data and send in chat

    Hi @Expiscornovus thanks for taking the time to answer. If it's possible I'd like to include a graph, but a simple "Count" of something would be nice. Any content from the Power BI dashboard actually. 

  • Expiscornovus Profile Picture
    Expiscornovus 1,667 on at
    Re: Get Power BI data and send in chat

    Hi @EMIL_K_DIT,

     

    Just to clarify your requirement.

     

    Is it sufficient to send a link of the Power BI report or do you want to include a chart in the chat window of the chat bot?

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,954

#3
Expiscornovus Profile Picture

Expiscornovus 1,667

Featured topics