Why can data only be queried in Power BI Report Builder?

[HamidBee]

Why can data only be queried into Power BI Report Builder?. I can't just import and excel file or csv file for instance. I'm just curious as to why that is. 

[Anonymous · Accepted solution]

Hi @HamidBee ,

 The report builder uses similar DAX functions used in Power BI.  

• Create paginated reports with table, matrix, chart, and free-form report layouts. Create table reports for column-based data, matrix reports (like cross-tab or PivotTable reports) for summarized data, chart reports for graphical data, and free-form reports for anything else. Reports can embed other reports and charts, together with lists, graphics, and controls for dynamic Web-based applications.

• Report from a variety of data sources. You can create reports that use relational and multidimensional data from SQL Server and Analysis Services, Oracle, Power BI datasets, and other databases.

More details: Power BI Report Builder 

I have also found a similar post, please refer to it to see if it helps you.

Report Builder Query Designer 

• when using Paginated reports it is connecting to the Tabular Model which has a query language called DAX.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.