Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
9 years ago
Solved

power bi - tabular data

hi, do power BI can 'get data' from data source that is not tabular? are there are any constraints?   thanks
Need Help
MP_123's avatar
MP_123
Microsoft Employee
9 years ago

i am exploring PBI and i just want to know whether there are constraint on the data which PBI expecting to get.

whether it should be tabular only, bacause as i see the 'query editor' on pbi desktop show the data in a tabular way

 

thanks ! vanessafvg

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

MP_123

 

Power BI Desktop internally creates temporary Aanalysis Services Tabular/PowerPivot model database for each created .pbix file. That's the reason it always show data in tabular way. Please refer to articel below:

 

Connect to Power BI Desktop Model from Excel and SSMS

 

Regards,