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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Power BI integration using ODBC driver and data gateway

Hi,

I'm new to Power BI and my question is basic. 

I need to connect Power BI desktop to a service for which a pre-designed connector is not available. Then I need to make a dashboard and get it published with refresh capability. My research shows I should use an ODBC driver and then gata dateway to get the dashboard refreshed. 

Is it the right way? If so, what are the steps I need to take? I would really appreciate it if you can breeak the process down.

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

Please follow the steps below.

1. Get data in power bI desktop with the ODBC connector and create your report and publish it to Power BI Service.

2. Assuming that you have installed the data gateway, you could add your data souce in the gateway. Please refer to this guide docuemnt. If you have not installed the gateway, please follow this article.

3. Edit your credential and set schedule refresh under Setting>> Dataset in Power BI Service.

If you still need help, please feel free to ask.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Cherry,

Thanks for the links. Big help. I will start the project next week and probably ask more questions 🙂

 

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

Please follow the steps below.

1. Get data in power bI desktop with the ODBC connector and create your report and publish it to Power BI Service.

2. Assuming that you have installed the data gateway, you could add your data souce in the gateway. Please refer to this guide docuemnt. If you have not installed the gateway, please follow this article.

3. Edit your credential and set schedule refresh under Setting>> Dataset in Power BI Service.

If you still need help, please feel free to ask.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi, should I use gateways to connect my Firebase data to PowerBI?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors