0

I am new to Stored procedures & OpenQuery in Power BI.

I am trying to connect to my SQL Server database by passing an SQL statement:

SELECT * FROM OPENQUERY ([DVT-FUSION],
'EXEC CRM_DVT.dbo.SP_RPT_Billing_Summary ''R1'', ''R2'', ''0'', ''0''  ')

But for some reason I get back an error stating:

Microsoft SQL: Server 'DVT-FUSION' is not configured for DATA ACCESS.

Foxan Ng
  • 6,883
  • 4
  • 34
  • 41
Rush
  • 83
  • 3
  • 3
  • 10

1 Answers1

0

As the error suggested, you database is not configured for DATA ACCESS.

You should run this once on your SQL Server instance:

EXEC sp_serveroption 'DVT-FUSION', 'DATA ACCESS', 'true';
Foxan Ng
  • 6,883
  • 4
  • 34
  • 41
  • Thanks @FoxanNg, it worked. I would like to know how can I get the date as a field to filter my report? – Rush Jan 24 '17 at 10:03
  • @Rush Can you accept this answer as correct and ask the new question in a separate question with more details? – Foxan Ng Jan 24 '17 at 10:28
  • Sure, I will post a new question if I cannot resolve it. Thanks. – Rush Jan 24 '17 at 10:33
  • Hi @Rush Please mark this answer as accepted as shown [here](https://meta.stackexchange.com/a/5235/313506) if it helps solving your issue. Thanks! – Foxan Ng Mar 23 '17 at 16:38