topic Powre BI Reports for Power BI Report Server in Report Server

Powre BI Reports for Power BI Report Server

mdaamirkhan — Sat, 02 Jun 2018 06:27:19 GMT

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

Thanks

Aamir

Re: Powre BI Reports for Power BI Report Server

Anonymous — Mon, 04 Jun 2018 12:58:07 GMT

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?

Re: Powre BI Reports for Power BI Report Server

mdaamirkhan — Mon, 04 Jun 2018 16:25:36 GMT

Excel file its in my D:\ drive.

File is not open

I have the access to the shared loaction

Yes

Now what to do

Re: Powre BI Reports for Power BI Report Server

Anonymous — Tue, 05 Jun 2018 07:51:24 GMT

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

Anonymous — Tue, 05 Jun 2018 07:56:47 GMT

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

Re: Powre BI Reports for Power BI Report Server

mdaamirkhan — Tue, 05 Jun 2018 08:43:03 GMT

Ok I will try and let you know