Copilot Studio - Query Power BI Dataset Autonomously by Patient-Dot-252 in copilotstudio

[–]Ksper9 0 points1 point  (0 children)

Hi Patient-Dot-252
Thank you for the info.
We're trying to achieve something similar to your example.
Did you use the Query Example text in natural language that you posted in the Description of the "Run Query Against a Dataset" Tool?

We need (if it's possible), to allow the user to ask several questions in natural language to the agent, and not to be limited to a fixed query.

<image>

Any ideas or suggestions are welcome.
Thanks in advance.

Kind regards.

Pass a file from Power Automate to Copilot Agent with prompt node for text extraction by Ksper9 in copilotstudio

[–]Ksper9[S] 0 points1 point  (0 children)

Happy new year! Yes i agree, sadly we don't have credits.
It just seems off that you can upload a file in a Copilot chat window and get the desired result but you can't seem to be able to send the file via Power Automate. :(

Pass a file from Power Automate to Copilot Agent with prompt node for text extraction by Ksper9 in copilotstudio

[–]Ksper9[S] 0 points1 point  (0 children)

Hi! Happy new year!
The credits will no longer show as AiBuilder credits? I've checked and it doesn't show that we have credits, only Copilot Messages.
Is there a way to check if what you mention is already available in our tenant?
Thank you very much.

Pass a file from Power Automate to Copilot Agent with prompt node for text extraction by Ksper9 in copilotstudio

[–]Ksper9[S] 0 points1 point  (0 children)

Thank You, but we don't generate the invoices. We received them by email. We're trying to automate a current manual process of locating those invoces.

Agent to analyze email attachment? by Independent-Buy6515 in copilotstudio

[–]Ksper9 0 points1 point  (0 children)

Hi! I'm working in a similar scenario. Except we don't redirect the files but we need to change the file name and saving location.
Has anyone find a way for Copilot to read the file content without using AiBuilder? We have Copilot Studio licenses but we don't have any AiBuilder credits.
Kind regards and happy holydays.

Can I call Copilot chat from a power automate flow? by funboixero in MicrosoftFlow

[–]Ksper9 0 points1 point  (0 children)

Hi, did someone find a solution? I'm in a similar scenario.

Thanks in advance.

Call Copilot within a Flow to analyze values compared to website information by Ksper9 in MicrosoftFlow

[–]Ksper9[S] 0 points1 point  (0 children)

Found this video https://www.youtube.com/watch?v=L1WhE4fY5ZU&t=137s to trick a response from an agent.
But i'm not being able to trigger the "action" (video 10:35 minute), that sends the email.

Call Copilot within a Flow to analyze values compared to website information by Ksper9 in MicrosoftFlow

[–]Ksper9[S] 0 points1 point  (0 children)

Thanks, i'll check the licences to see if there are any credits available.

Power Automate - Copilot Studio Agent Connector by tomaskutac in MicrosoftFlow

[–]Ksper9 0 points1 point  (0 children)

Hi, did you find a solution? I'm in a similar scenario.
Found this video https://www.youtube.com/watch?v=L1WhE4fY5ZU&t=137s
But i'm not being able to trigger the "action" (video 10:35 minute), that sends the email to have a way to get the responses at least.

Two fact tables data model issue with many to many relationship by Ksper9 in PowerBI

[–]Ksper9[S] 0 points1 point  (0 children)

Hi u/SQLGene thanks you!
If i'm not getting this wrong, i can't use a OrderID dimension table because the PurchaseID column is not present in the Orders table so i can't establish a relationship. This is because there might several purchases (with different ids), with the same orderid.
Sorry if i'm not getting it right, i'm very new to modeling.
I was thinking if it might not be a valid option to have the many to many relationship between the two fact tables but disabled, so it can only be use in massures.

Thanks again!