Forum Discussion

rusty19's avatar
rusty19
Regular Visitor
7 months ago
Solved

Creating a dynamic task list for recurring reports in Power Query (Power BI)

I am trying to create a recurring task calendar in Power Query (Power BI) for the different reports that our group has to run.  Here is what I have:   Date table including working and non-working d...
Need Help
  • rusty19's avatar
    rusty19
    7 months ago

    I have figured it out on my own with a little patience.  Thank for your help.

     

    This can be closed.

lbendlin's avatar
lbendlin
Super User
7 months ago
I am trying to create a recurring task calendar in Power Query (Power BI) for the different reports that our group has to run.

Power BI is a reporting tool, not a task scheduler. Use the apps that were designed for that (Task Scheduler, Outlook etc).

  • rusty19's avatar
    rusty19
    Regular Visitor
    7 months ago

    I understand your comment, but the Power BI part of this is only the end game for displaying the schedule per report and creating a reports calendar.

     

    I will be using Power Automate to display taskings in the proper MS tools.

    • v-saisrao-msft's avatar
      v-saisrao-msft
      Community Support
      7 months ago

      Hi rusty19,

      As you mentioned, using Power Automate for task orchestration and Power BI only for displaying the resulting schedule and calendar view is the right separation of responsibilities. Could you please confirm whether this approach has resolved your issue?

       

      Thank you.

      • rusty19's avatar
        rusty19
        Regular Visitor
        7 months ago

        Hello,

        sorry for the delay.  Not this does not resulve the issue.  I have the beginning (the data and different tables) and the end (Power BI reports) but I am missing the middle - how to 'expand/merge' all the information together.  I think there is a begining of an answer in this chat.

        Thx.