Valid PL-300 Dumps shared by ExamDiscuss.com for Helping Passing PL-300 Exam! ExamDiscuss.com now offer the newest PL-300 exam dumps, the ExamDiscuss.com PL-300 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com PL-300 dumps with Test Engine here:
Access PL-300 Dumps Premium Version
(452 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 119/147
You have a Microsoft SharePoint Online site that contains several document libraries.
One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.
What should you do?
One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.
What should you do?
Correct Answer: B
- Question List (147q)
- Question 1: You are enhancing a Power BI model that has DAX calculations...
- Question 2: You need to create a Power BI theme that will be used in mul...
- Question 3: You use Power 81 Desktop to load data from a Microsoft SQL S...
- Question 4: You have a Power Bl workspace named Workspace1 that contains...
- Question 5: You have a dataset named Pens that contains the following co...
- Question 6: You have a table that contains the following three columns: ...
- Question 7: You have a collection of reports for the HR department of yo...
- Question 8: You have a Power Bl workspace that contains a dataset. a rep...
- Question 9: Note: This question is a part of a series of questions that ...
- Question 10: (Exhibit) Each employee has one manager as shown in the Pare...
- Question 11: You are building a dataset from a JSON file that contains an...
- Question 12: You have a query named Customer that imports CSV files from ...
- Question 13: In Power Bi Desktop, you are creating visualizations in a re...
- Question 14: Note: This question is part of a series of questions that pr...
- Question 15: You build a Power Bl report that displays 10T temperature da...
- Question 16: Note: This question is part of a series of questions that pr...
- Question 17: You have the following table named Location. (Exhibit) The G...
- Question 18: You are creating a visual to show the ranking of product cat...
- Question 19: A business intelligence (Bl) developer creates a dataflow in...
- Question 20: Note: This question is part of a series of questions that pr...
- Question 21: You have a project management app that is fully hosted in Mi...
- Question 22: Note: This question is part of a series of questions that us...
- Question 23: Note: This question is part of a series of questions that pr...
- Question 24: You have a Power Bl table named Customer that contains a fie...
- Question 25: You build a report about warehouse inventory data. The datas...
- Question 26: You need to recommend a strategy to consistently define the ...
- Question 27: You need to address the data concerns before creating the da...
- Question 28: You are creating a sales report in Power Bl for the NorthWes...
- Question 29: You have sales data in a star schema that contains four tabl...
- Question 30: You have a Microsoft SharePoint Online site that contains se...
- Question 31: You need to create a Power BI report. The first page of the ...
- Question 32: You have a dataset that is used infrequently and refreshes e...
- Question 33: You have a Power BI report. You need to create a calculated ...
- Question 34: You have a Power BI model that contains a table named Sales ...
- Question 35: You publish the dataset to powerbi.com. For each of the foll...
- Question 36: You receive annual sales data that must be included in Power...
- Question 37: You have a Microsoft Excel workbook that contains two sheets...
- Question 38: You have four sales regions. Each region has multiple sales ...
- Question 39: Note: This question is part of a series of questions that pr...
- Question 40: You need to create a visual as shown in the following exhibi...
- Question 41: Note: This question is part of a series of questions that pr...
- Question 42: You have a Power BI dashboard that monitors the quality of m...
- Question 43: You need to create the dataset. Which dataset mode should yo...
- Question 44: You plan to use Power BI Desktop optimized for Power BI Repo...
- Question 45: You have a Power BI report. The report contains visualizatio...
- Question 46: You plan to create a report that will display sales data fro...
- Question 47: You need to create the relationship between the product list...
- Question 48: What is the minimum number of Power BI datasets needed to su...
- Question 49: Note: This question is part of a series of questions that pr...
- Question 50: You create a data model in Power BI. Report developers and u...
- Question 51: You import two Microsoft Excel tables named Customer and Add...
- Question 52: You have an API that returns more than 100 columns. The foll...
- Question 53: You have multiple dashboards. You need to ensure that when u...
- Question 54: Note: This question is part of a series of questions that pr...
- Question 55: You have a Power Bl report. You have the following tables. (...
- Question 56: In Power BI Desktop, you have a dataset that contains a tabl...
- Question 57: You plan to develop a Power BI report that has a bar chart t...
- Question 58: Note: This question is part of a series of questions that pr...
- Question 59: You have a Power Bl report You have a table named Dalai that...
- Question 60: You have a Microsoft Power BI report. The size of PBIX file ...
- Question 61: You manage a Power BI model has a table named Sales and prod...
- Question 62: You have a Power Bl report that contains three pages. The pa...
- Question 63: Note: This question is part of a series of questions that pr...
- Question 64: You have the visual shown in the exhibit. (Click the Exhibit...
- Question 65: You have the Azure SQL databases shown in the following tabl...
- Question 66: Exhibit: (Exhibit) You need to create a report that meets th...
- Question 67: You are creating a Microsoft Power Bl imported data model to...
- Question 68: You have a Power Bl report that contains five pages. Pages 1...
- Question 69: You have a Power BI imported dataset that contains the data ...
- Question 70: Note: This question is part of a series of questions that pr...
- Question 71: Note: This question is part of a series of questions that pr...
- Question 72: You have a Microsoft Exert spreadsheet named Excel1 that con...
- Question 73: Note: This question is part of a series of questions that pr...
- Question 74: A manager can represent only a single country. You need to u...
- Question 75: You need to create a calculated column to display the month ...
- Question 76: You have a Power BI report that contains a page. The page co...
- Question 77: You have the following three versions of an Azure SQL databa...
- Question 78: You need to create a measure that will return the percentage...
- Question 79: You are creating a Power Bi model in Power BI Desktop You ne...
- Question 80: You need to create a Power Bl theme that will be used in mul...
- Question 81: Note: This question is part of a series of questions that pr...
- Question 82: Note: This question is part of a series of questions that pr...
- Question 83: Note: This question is part of a series of questions that pr...
- Question 84: You have a table that contains a column named Phone. The fol...
- Question 85: Note: This question is part of a series of questions that us...
- Question 86: You have a Power Bl report hosted on powerbi.com that displa...
- Question 87: You need to create a relationship in the dataset for RLS. Wh...
- Question 88: You have a Microsoft Excel file in a Microsoft OneDrive fold...
- Question 89: You have a prospective customer list that contains 1,500 row...
- Question 90: You import two Microsoft Excel tables named Customer and Add...
- Question 91: You have a report in Power BI Desktop. You add a key influen...
- Question 92: You are modifying a Power Bi model by using Power Bl Desktop...
- Question 93: You have two CSV files named Products and Categories. The Pr...
- Question 94: You need to create a measure that will return the percentage...
- Question 95: You have a Power B1 report that contains three pages named P...
- Question 96: You have a Microsoft Power Bl workspace. You need to grant t...
- Question 97: You have a Power B1 model that contains a table named Date. ...
- Question 98: You are creating a Power BI model that contains a table name...
- Question 99: You have two Azure SQL databases that contain the same table...
- Question 100: You have a CSV file that contains user complaints. The file ...
- Question 101: You have a Power BI report that contains four pages. All the...
- Question 102: You need to minimize me size of the dataset. The solution mu...
- Question 103: You have a BI dataset and a connected report. You need to en...
- Question 104: You have the Power Bl data model shown in the following exhi...
- Question 105: You have the tables shown in the following table. (Exhibit) ...
- Question 106: You have a Power BI data model that analyzes product sales e...
- Question 107: In the Power BI service, you create an app workplace that co...
- Question 108: Remove unused columns from tables in the data model. This wi...
- Question 109: You have multiple dashboards. You need to ensure that when u...
- Question 110: You have a report in Power BI Desktop as shown in the follow...
- Question 111: You have a Power Bl report for the marketing department. The...
- Question 112: You plan to embed multiple visualization in a public website...
- Question 113: Note: This question is part of a series of questions that pr...
- Question 114: You have a Power Bl report that contains a measure named Tot...
- Question 115: You have the Power BI data model shown in the following exhi...
- Question 116: You need to create a visualization to meet the reporting req...
- Question 117: You have a Power Bl workspace named Inventory that contains ...
- Question 118: You have a Microsoft Power Bl dashboard. The report used to ...
- 2 commentQuestion 119: You have a Microsoft SharePoint Online site that contains se...
- Question 120: You are preparing a financial report in Power BI. You connec...
- Question 121: In Power BI Desktop, you are creating a report that will con...
- Question 122: You have a Power BI model that has the following tables: * P...
- Question 123: You have a query named All Sales that imports sales data int...
- Question 124: You create the following step by using Power Query Editor. =...
- Question 125: You need to grant access to the business unit analysts. What...
- Question 126: You need to design the data model and the relationships for ...
- Question 127: You have a Power BI model that contains the following data. ...
- Question 128: You have a Power Bl visual that uses indicators to show valu...
- Question 129: You are creating a Power Bl report by using Power Bi Desktop...
- Question 130: You have a Power BI report named Report' and a dashboard nam...
- Question 131: Note: This question is part of a series of questions that pr...
- Question 132: You have a Power BI data model that contains a table named E...
- Question 133: You have a Power Bl workspace that contains a single-page re...
- Question 134: ion have a Power BI dataset that contains a table named Temp...
- Question 135: You have an Azure SQL database that contains sales transacti...
- Question 136: You need to create the On-Time Shipping report. The report m...
- Question 137: The Sales table contains records of sales by day from the la...
- Question 138: You have an app workspace named Retail Analysis in the Power...
- Question 139: Note: This question is part of a series of questions that pr...
- Question 140: You are building a Power BI report to analyze customer segme...
- Question 141: You have an on-premises Power BI Report Server. You plan to ...
- Question 142: You are creating reports in Power BI Desktop. The model has ...
- Question 143: You have a Power BI model that contains a table named Sales....
- Question 144: You need to create the On-Time Shipping report. The report m...
- Question 145: You use an R visual to produce a map of 500,000 customers. Y...
- Question 146: You need to create a visualization that compares revenue and...
- Question 147: You build a Power Bl report that displays 10T temperature da...
Recent Comments (The most recent comments are at the top.)
correct answer is : A
Get Data from SharePoint folder + select Combine & Load to load the data from all of the files in the SharePoint folder directly into your app.
Note: Connect to a SharePoint folder from Power Query Desktop
To connect to a SharePoint folder:
1. From Get Data, select SharePoint folder.
2. Paste the SharePoint site URL you copied in Determine the site URL to the Site URL text box in the SharePoint folder dialog box. In this example, the site URL is https://contoso.sharepoint.com/marketing/data. If the site URL you enter is invalid, a warning icon. warning icon will appear next to the URL text box.
SharePoint folder selection.
3. Select OK to continue.
4. If this is the first time you've visited this site address, select the appropriate authentication method. Enter your credentials and choose which level to apply these settings to. Then select Connect.
5. When you select the SharePoint folder you want to use, the file information about all of the files in that SharePoint folder are displayed. In addition, file information about any files in any subfolders is also displayed.
6. Select Combine & Transform Data to combine the data in the files of the selected SharePoint folder and load the data into the Power Query Editor for editing. Or select Combine & Load to load the data from all of the files in the SharePoint folder directly into your app....
Answer is A. Get data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library,
because multiple files are located in folder in power BI.