Forum Discussion
Kudo CommanderConnecting Power BI Desktop to MS SQL Server on AWS and Publishing to Power BI Service
Hi manoj_0911
Perhaps the following will help.
1. Connection Setup:
Enter the AWS instance endpoint into the server name. Select either "Import" or "DirectQuery" mode as needed. "Import" mode imports data into Power BI's in-memory engine, while "DirectQuery" mode maintains a live connection to the database.
2. For some limitations of the different connection modes, please refer to the following documentation:
DirectQuery in Power BI - Power BI | Microsoft Learn
3. One thing that needs to be corrected is that dashboards are created in the Power BI service, not in Desktop. First, create reports in Power BI Desktop using visualizations. For more details, you can read related document link:
Create reports and dashboards in Power BI - documentation - Power BI | Microsoft Learn
4. You can publish reports to my workspace or workspace. myworkspace is a personal workspace that allows you to use your own content, not collaborate with others. if you need to collaborate, you need to create a workspace. to collaborate in a workspace or share content with others in Power BI services, you need a Power BI Pro or Premium Per User (PPU) license. For more details, you can read related document link:
Publish from Power BI Desktop - Power BI | Microsoft Learn
Basic concepts for designers in the Power BI service - Power BI | Microsoft Learn
Workspaces in Power BI - Power BI | Microsoft Learn
Create a workspace in Power BI - Power BI | Microsoft Learn
5. Before configuring refresh, you need to configure the gateway. Gateways are the bridge between local data and cloud services. For more details about gateway, you can read related document link:
What is an on-premises data gateway? | Microsoft Learn
Add or remove a gateway data source - Power BI | Microsoft Learn
About Refresh:
Data refresh in Power BI - Power BI | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft Learn
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi manoj_0911
Perhaps the following will help.
1. Connection Setup:
Enter the AWS instance endpoint into the server name. Select either "Import" or "DirectQuery" mode as needed. "Import" mode imports data into Power BI's in-memory engine, while "DirectQuery" mode maintains a live connection to the database.
2. For some limitations of the different connection modes, please refer to the following documentation:
DirectQuery in Power BI - Power BI | Microsoft Learn
3. One thing that needs to be corrected is that dashboards are created in the Power BI service, not in Desktop. First, create reports in Power BI Desktop using visualizations. For more details, you can read related document link:
Create reports and dashboards in Power BI - documentation - Power BI | Microsoft Learn
4. You can publish reports to my workspace or workspace. myworkspace is a personal workspace that allows you to use your own content, not collaborate with others. if you need to collaborate, you need to create a workspace. to collaborate in a workspace or share content with others in Power BI services, you need a Power BI Pro or Premium Per User (PPU) license. For more details, you can read related document link:
Publish from Power BI Desktop - Power BI | Microsoft Learn
Basic concepts for designers in the Power BI service - Power BI | Microsoft Learn
Workspaces in Power BI - Power BI | Microsoft Learn
Create a workspace in Power BI - Power BI | Microsoft Learn
5. Before configuring refresh, you need to configure the gateway. Gateways are the bridge between local data and cloud services. For more details about gateway, you can read related document link:
What is an on-premises data gateway? | Microsoft Learn
Add or remove a gateway data source - Power BI | Microsoft Learn
About Refresh:
Data refresh in Power BI - Power BI | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft Learn
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.