Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
techsantosh
New Member

Power BI report data source authentication type changes when uploaded to Power BI report server

Hi,

 

I am new to Power BI server. I have created simple power BI report with SQL server database as data source using power BI desktop.

Here I am using authentication type as Database.

1.JPG

 

Till here everything is fine!!!

 

Now I uploaded this report on Power BI Report server, it got uploaded successfully.

2.JPG

But when I tried to open this report from report web portal it shows :

3.JPG

When I checked Data Sources tab from Manage option (In Report server), the authentication type is changed to Windows (It was 'Databse' when created)

4.JPG

What is the issue? Did I miss something while uploading?

Thanks in advance.

 

NOTE : If I change authentication type from Power BI Report server then report is working fine.

 

Report Server details :

6.JPG

Power BI Desktop details :

5.JPG

 

2 REPLIES 2
ChrisMuthmann
Helper II
Helper II

It is still the same for me. Any updates on this issue?

Thanks

Anonymous
Not applicable

I am also facing same..any one can help?

Thnx.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.