web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dynamics GP - SQL Rest...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Dynamics GP - SQL Restore to Azure

(1) ShareShare
ReportReport
Posted on by Muhammad Ahsan Tufail 315
Hi ,
 
Anyone tried SQL DB on Azure just for SSRS and Power BI reports? looking forward for some suggestions. 
Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,538 Super User 2025 Season 2 on at
    Good morning, afternoon, or evening depending on your location!
    Hope you are well today :)
     
    Restoring a Dynamics GP SQL database to Azure for SSRS and Power BI reporting is definitely possible, and there are a few approaches to consider:
    Options for Running SQL DB on Azure for SSRS & Power BI
    1. Azure SQL Managed Instance
      • If you need full SQL Server compatibility, an Azure SQL Managed Instance is a great choice.
      • It supports SQL Agent, SSRS, and linked servers, making it ideal for Dynamics GP reporting.
    2. Azure SQL Database (PaaS)
      • If you only need Power BI reporting, you can restore your GP database to Azure SQL Database.
      • Keep in mind that SSRS is not natively supported in Azure SQL Database, so you may need an alternative reporting solution.
    3. Azure Virtual Machine with SQL Server
      • If you want full SSRS functionality, deploying SQL Server on an Azure VM allows you to run SSRS just like an on-prem setup.
      • This option provides the most flexibility but requires VM management.
    4. Power BI Direct Query or Dataflows
      • If SSRS isn’t a requirement, you can use Power BI Direct Query to connect to Azure SQL Database.
      • Dataflows can also be used to transform and store GP data for reporting.
    Key Considerations
    • Performance: Azure SQL Managed Instance offers better performance for GP workloads than Azure SQL Database.
    • Licensing Costs: Azure VM with SQL Server may have higher costs due to compute and storage.
    • SSRS Hosting: If SSRS is critical, an Azure VM is the best option. Otherwise, consider Power BI Paginated Reports.
     
    Hope this is helpful :)
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at
    Granted I don’t know anything about Dynamics GP, but I’d start by seeing how far I can come with just installing the Microsoft On-Premises data gateway against a test environment before restoring a backup to Azure.
     
    What are your needs exactly? Do you want to set up analytics against the database?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans