topic Report Server data connection in Report Server

Report Server data connection

Anonymous — Wed, 08 Apr 2020 06:44:20 GMT

Hi Team,

A few of question about Report Server.

1. WHY do we still need to have Pro license for us to be able to upload our PBIX files into Power BI Report Server?

2. WHEN connected to on-prem AS server via Power BI desktop, and upload the file to Report Server, do the connection get retain? 3. HOW does it work when uploading to different environment (i.e. UAT and PROD). Is it just simple as changing the Report Server url in Power BI desktop?

Cheers,
Gil

Re: Report Server data connection

Greg_Deckler — Wed, 08 Apr 2020 10:17:25 GMT

1. Rules

2. Not sure I understand the question

3. Most people use Query Parameters

Re: Report Server data connection

Anonymous — Wed, 08 Apr 2020 22:23:56 GMT

For No. 2:

So I uploaded a pbix file to Report Server and it was successful. However if I try view ther report, this message pop up. I have to edit the data source manually.

I have to change the credentials manually to "Using the following credentials" instead.

Is there something that I need to setup so that when I upload the files, I don't need to manually changed the data sources?

Thanks in advance.

Re: Report Server data connection

Anonymous — Mon, 13 Apr 2020 13:39:55 GMT

#1. in our company we have only 3 Pro licenses but all the developers are able to upload to PBIRS.

you dont need a PRO license to upload.

Re: Report Server data connection

KBO — Mon, 13 Apr 2020 13:59:12 GMT

Hi Anonymous ,

don't let Microsoft hear you say that ;).

As Greg_Deckler mentioned it its a rule that if you a developer and upload reports you need a Pro Licence even if nobody can control it.

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Re: Report Server data connection

KBO — Mon, 13 Apr 2020 14:04:01 GMT

Hi Anonymous ,

I think there is no option at the moment.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19832149-shared-data-source-connection-live-to-tabular-ssa

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!