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
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

MP_123 can you explain more about what you mean, provide an example of the data you referring to

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

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    MP_123 you can pull basically what ever you want into power bi, it becomes a tabular model in power bi, but what it does before power bi isn't restrictred by power bi  it just depends on how you doing things.

  • 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,