Forum Discussion

qianrusong's avatar
qianrusong
Frequent Visitor
2 years ago

Connect datasets from the published report

Hello,

 

I publish a report every month and save them in a workspace. I need to create a new desktop report where i want to pull the same output tables from each monthly published report of the workspace as my input. can I do it directly? if not, what is the altertantive way to handle it without replicating the report again? thanks a lot. 

Need Help

5 Replies

  • anmolmalviya05's avatar
    anmolmalviya05
    Super User
    2 years ago

    Hi qianrusong, Hope you are doing good!

    You can achieve this using Power BI Semantic Model. Whenever you publish a report in workspace, a dataset will get created automatically. You can connect to it directly in Desktop.
    Go to Home > Get Data > Power BI Semantic Model.

    Here you will find list of all the datasets in your workspace.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

  • qianrusong's avatar
    qianrusong
    Frequent Visitor
    2 years ago

    it looks like that I cannot load it in power query where i expect to append all monthly results. is there any solution for that? thanks again.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi qianrusong ,

      Thank you anmolmalviya05 very much for the solution,  to help you understand the problem, I also tried some other ways to solve the problem:

      The problem you encountered should be due to some permissions have not been changed, or you do not have the highest permissions,

      if you need to perform your needs, I recommend that you re-download pbix from the power bi service to the local , you can open the power query interface.

       

       

      Hope it helps!

       

      Best regards,
      Community Support Team_ Tom Shen

       

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi qianrusong ,

      Regarding the issue we discussed earlier, I wonder if this has been resolved now? It's been a long time since I've heard back from you and I'm not sure if all is well. Please feel free to let me know if there is anything else I can do to help.

       

      Hope it helps!

       

      Best regards,
      Community Support Team_ Tom Shen

       

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.