Connect datasets from the published report

[qianrusong]

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. 

[qianrusong]

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.

[v-xingshen-msft]

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.

[v-xingshen-msft]

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.

[qianrusong]

I see, thanks for the quick answer.

[anmolmalviya05]

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 !!