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

Powre BI Reports for Power BI Report Server

Hello All,

 

I have Install Power BI Report Server in my PC Windows 10 and SQL Server 2014. I create one reprot in power bi and save as to Report server and configure the Data Source as well and test connection successfull. When I click browse and then click the reprot which I have create it not showing. I have share the screenshot. Can you please help on this. How to solved the issue

2.PNGData Source1.PNGWhile loading it get error could not cooenct to the data source3.PNGNothing loaded

 

Thanks

Aamir

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Powre BI Reports for Power BI Report Server

In order to use Windows Authentication you need to configure Kerberos.

 

See this post: https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports

 

 

View solution in original post

5 REPLIES 5
stpnet Established Member
Established Member

Re: Powre BI Reports for Power BI Report Server

That looks like a securtity problem.

 

Are you sure the share where you have saved the Excel exists and is correct?

Does the Excel file exist? 

Has someone else got that Excel file open?

Has the User you are accessing it as got access to the share?

Has the service account running your PBI-SSRS service got access to the share?

Has the Service Account running your SQL Agent service got access to the share?

mdaamirkhan Member
Member

Re: Powre BI Reports for Power BI Report Server

Excel file its in my D:\ drive.

File is not open

I have the access to the shared loaction 

Yes

Yes

 

Now what to do

stpnet Established Member
Established Member

Re: Powre BI Reports for Power BI Report Server

Is your D drive visible from wherever the SSRS-PBI server is running?

 

The screenshot suggested it was looking at a network share for the excel file \\server\powerbi\inputfile\book1.xlsx

 

Is this correct? I'd expect this to look more like \\machine_name\share_name\folder_path\file_name

Re: Powre BI Reports for Power BI Report Server

In order to use Windows Authentication you need to configure Kerberos.

 

See this post: https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports

 

 

View solution in original post

Highlighted
mdaamirkhan Member
Member

Re: Powre BI Reports for Power BI Report Server

Ok I will try and let you know 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 47 members 797 guests
Please welcome our newest community members: