Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi All,
I am trying to connect Power BI with SQL server for retail POS system. It's a vendor built system so I have no or very limited knowledge about the system architect. I have basic understanding about databases and wondering if someone can help me understand the difference between image shown for VI* tables vs. AI* tables in below image. So far I have only seen the table image as shown for AI* databases. Can anybody here explain the difference to me? Thanks a lot in advance.
Solved! Go to Solution.
Hi @moezsajwani,
According to your description, your requirement seems more related to SQL database.
I'd like to suggest you post to SQL Server related forum to get better support.
Msdn forums - SQL Server - Microsoft
Difference between View and table in sql
Regards,
Xiaoxin Sheng
Hi @moezsajwani,
According to your description, your requirement seems more related to SQL database.
I'd like to suggest you post to SQL Server related forum to get better support.
Msdn forums - SQL Server - Microsoft
Difference between View and table in sql
Regards,
Xiaoxin Sheng
The top 3 are views, the other 2 are tables
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 33 | |
| 32 | |
| 31 | |
| 26 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |