Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ananaqaco
Frequent Visitor

Visio in PowerBI

Hello, 

I have a dataset that includes source from SQL and Visio. When I upload it to server and try to refresh it, I have an error. It says to install personal gateway.  I have on premis gateway that is for SQL server. could anyone help me with this?

 

3 REPLIES 3
v-rongtiep-msft
Community Support
Community Support

Hi @Ananaqaco ,

The error message you are seeing suggests that you need to install a personal gateway to refresh your dataset in Power BI.You mentioned that you already have an on-premises gateway that is for SQL server. However, it is possible that you need to install a personal gateway for your Visio data source.

 

Power BI personal gateway is a tool that enables users to refresh their on-premises data in Power BI. It connects to a variety of data sources and allows users to schedule automatic data to refresh in the Power BI service.

Use a personal gateway in Power BI - Power BI | Microsoft Learn

Power BI - Differences between Power BI personal Gateway and Data Management Gateway - GeeksforGeeks

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Thanks for the answer, I have onpremis gateway for sql server, if I add personal gateway too the dataset won't get which gateway to use, I can't use both gateways for the same dataset. 

Hi @Ananaqaco ,

You need to install the personal gateway to refresh the dataset. The personal gateway is for Power BI only and can be used as an individual without any administrator configuration. You can install up to two On-premises data gateways on the same computer, one running in each mode (personal and standard)

 

A gateway must be installed and running for Power BI to connect to on-premises data sources and refresh the dataset.

Refresh datasets created from local Power BI Desktop files - Power BI | Microsoft Learn

Data refresh in Power BI - Power BI | Microsoft Learn

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.