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
nil71mp
New Member

PowerBI Data Connection

Hi, I am Tableau Developer just starting 

1. Can PowerBI connect to Tableau Data Source? (tdsx file)

2. Can PowerBI Connect to MSSQL Synonym? 

2 REPLIES 2
Sahir_Maharaj
Super User
Super User

Hello @nil71mp,

 

  1. Power BI does not have a direct built-in capability to connect to Tableau Data Source (.tdsx) files. Power BI and Tableau are separate data visualization tools with their own file formats. However, you can extract the data from Tableau Data Source files and save it in a format that Power BI supports, such as CSV, Excel, or a database, and then connect Power BI to that extracted data.

  2. Yes, Power BI can connect to MSSQL Synonyms. When connecting to a Microsoft SQL Server database, Power BI can recognize and work with synonyms in the same way as tables or views. You can select the synonym object in the database connector when configuring the connection in Power BI and use it for data analysis and visualization.

Let me know if you might need further assistance.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 13K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Hi Sahir, 

Thank you very much for your prompt response and explanation. However,

1. Tableau published data sources can not be downloaded in other format than tdsx. Only workbooks can be extracted in cvs or excel format. 

2. I am able to connect to SQL Server but and it shows all the tables and views but doesn't display/recognize any synonyms. I don't see them in power bi which I can connect in tableau and see them in MSSQL. Power BI doesn't show entire foler for synonyms. It will be helpful if you can point me to any required changes that need to be made to views them. 

Thanks again.

Nil 

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.