Forum Discussion
How do I make the basic connection to a report server
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.
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 RegardsLucien
1 Reply
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 RegardsLucien