up to what data range integrations are possible into Power BI

[Anonymous]

I have below 2 questions on Power BI

1)Up to what data range integrations are possible? in to Power BI

2)How many simultaneous ODBC connections ,power bi can accommodate?

Thanks

[Greg_Deckler]

Can you elaborate on 1? Are you referring to how much data you can import?

As for 2, several? How many are you looking to do and are they all tables in one ODBC source or multiple, different ODBC connections (sources)

[Anonymous]

For question 2: which are the several odbc connection we can use ? and what are those .

[vanessafvg]

@Anonymous  you have a 1gb limit per pbix file when you are publishing to the web service however this is for imported mode - are you referring to direct query mode or imported mode?    direct query because the data sits at the source there is not that limitation.

I dont think there is a limit of joins possible, it will be dependent on the source.

for the data sources look here

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-sources/

when you say odbc are you referring to SQL or what?  you can have as many connections as you need however in direct query mode i think you can only point to one  in one file.

[Anonymous]

@vanessafvg in General i am asking how many ODBC connction we can used while preparing single reports using ODBC connection into Power Bi and what are those. because when i checked there is 2 odbc connection available excel files and MS Access. can we use both simultaneously in one report?

[vanessafvg · Accepted solution]

@Anonymous in imported mode you can use multiple sources, in direct query mode you can only have one source.

[Anonymous]

@vanessafvg in direct query as well as i think live mode only one source can be used right?

Thanks for the help

[vanessafvg]

@Anonymous multiple tables in the source is possible - but you can only point to one database 

[Anonymous]

Great thanks for Answers.

[Anonymous]

for question 1 : 

Like the size of the files, limitations on data specifications, number of joins possible, noumber  of interactions among different sources i want to know