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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
mdaamirkhan
Post Prodigy
Post Prodigy

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

Data SourceData SourceWhile loading it get error could not cooenct to the data sourceWhile loading it get error could not cooenct to the data sourceNothing loadedNothing loaded

 

Thanks

Aamir

1 ACCEPTED SOLUTION
jcollinson2001
Resolver IV
Resolver IV

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
jcollinson2001
Resolver IV
Resolver IV

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

 

 

Ok I will try and let you know 

Anonymous
Not applicable

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?

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.