topic Re: Data source gryed out in Report Server

Data source gryed out

bshekher — Wed, 22 Aug 2018 04:05:23 GMT

I created a dashboard report with 10 tabs, everything was working fine. Data source was enabled.

Reports was not updating, so I deleted the report and resaved on the Power Bi Report server(March version). But data source is greyed out. I tried removing all the data source setting and readding them, still the data source is greyed out. I tried renaming to a different file, but data source is greyed out.

Any help ?

Re: Data source gryed out

Anonymous — Wed, 22 Aug 2018 09:20:10 GMT

Which type of datasource do you use?

Re: Data source gryed out

bshekher — Wed, 22 Aug 2018 23:22:43 GMT

SQL Server, windows authentication.

Able to replicate

I did further research, created a completely new Power BI Report. Everything was working. I could schedule the refresh. Refresh completed. Then I deleted the report from report server, exactly same thing happened data source greyed out, on saving the report back to report server. Data source doesnot get enabled even if you rename the file( save to Pwer Bi report server with a different name). Is there any help ?

Re: Data source gryed out

bshekher — Thu, 23 Aug 2018 02:22:17 GMT

Found a work around. Rather than power Bi desktop to save as Power Bi Report server. Upload the report through top menu. It's enables the data source.

Re: Data source gryed out

Anonymous — Tue, 24 Mar 2020 12:03:19 GMT

I too have the same issue. I have used the upload option in top of the Report server and still it is in greyed out condition only.

Re: Data source gryed out

Anonymous — Sun, 07 Jun 2020 13:37:04 GMT

I have re-builded the power bi desktop file with production configuration and uploaded once again. Now it looks fine.