cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Philky001
New Member

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.

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

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,

vluwangmsft_0-1658976715647.png

 

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

vluwangmsft_1-1658976715456.png

 

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

vluwangmsft_2-1658976715556.png

 

 

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

 

View solution in original post

1 REPLY 1
v-luwang-msft
Community Support
Community Support

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,

vluwangmsft_0-1658976715647.png

 

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

vluwangmsft_1-1658976715456.png

 

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

vluwangmsft_2-1658976715556.png

 

 

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

 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!