How do I make the basic connection to a report server

[Philky001]

I see where I can use published datasets in my organization but I would like to make my own. Where can I find out more about how to? I would need to run a query against the reporting server as we are not allowed to add to it, like stored procedures.

[v-luwang-msft · Accepted solution]

Hi  @Philky001 ，

You can create shared datasets, plus if your dataset is authenticated it will be easier to find when you connect to a shared dataset. However, when using Desktop to connect to a shared dataset, the connection mode is live connection. there are some limitations.

Please follow the articles below to check your settings,

link1: Manage dataset access permissions - Power BI | Microsoft Docs

link2: Publish an app in Power BI - Power BI | Microsoft Docs

To learn more details ,refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces 

https://www.bluegranite.com/blog/power-bi-shared-datasets-for-self-service-bi 

https://community.powerbi.com/t5/Desktop/live-connection-limitation/m-p/566199 

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

Best Regards

Lucien