Forum Discussion

martinl's avatar
martinl
Regular Visitor
9 years ago
Solved

Import Power Query (connection only) in to Power BI

Hi   I am just getting to grips with Power BI and am struggeling with getting my data into it.   In this instance, I have a folder full of spreadsheets that I use Power Query to merge together in...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi martinl，

    Do you connect to your Excel in Power BI Service or Power BI Desktop? If you use Power BI Desktop, connect to your Excel file via “Get Data->Excel” entry as follows.


    And actually, you don’t need to firstly connect to the folder full of spreadsheets use Power Query and then connect to Excel in Power BI Desktop. You can directly connect to the folder using “Get Data->File->Folder” entry in Power BI Desktop, you are able to merge data of theses spreadsheets into one table and create charts in Power BI Desktop.



    However, if you connect to Excel in Power BI Service, please connect to it via “Get Data->Files->Local File” entry and then choose “Import Excel data into Power BI”.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi martinl，

Do you connect to your Excel in Power BI Service or Power BI Desktop? If you use Power BI Desktop, connect to your Excel file via “Get Data->Excel” entry as follows.


And actually, you don’t need to firstly connect to the folder full of spreadsheets use Power Query and then connect to Excel in Power BI Desktop. You can directly connect to the folder using “Get Data->File->Folder” entry in Power BI Desktop, you are able to merge data of theses spreadsheets into one table and create charts in Power BI Desktop.



However, if you connect to Excel in Power BI Service, please connect to it via “Get Data->Files->Local File” entry and then choose “Import Excel data into Power BI”.


Thanks,
Lydia Zhang