Forum Discussion
Powerbi
I am new to Powerbi , I have already done report for Jan to may 2022 which the spreadsheet has Jan to may data, I have connected directly from excel source to powerbi(get data option)and completed the report.
NOW I HAVE JUNE DATA SEPARATELY IN EXCEL FILE, I HAVE TO PULL JUNE DATA DIRECTLY TO POWERBI DASHBOARD THAT I ALREADY DID JAN TO MAY .SO CAN ANYONE HELP ME WITH THIS? HOW TO PULL DIRECTLY TO POWER BI EXISTING DASHBOARD
Hi AtchayaP
A report can be created using data from only one dataset. Power BI Desktop can combine more than one data source into a single dataset in a report, and that report can be imported into Power BI Service. However, Power BI Service cannot add new data sources to an existing dataset.
Since you want to add June data from a new file, you need to use Power BI Desktop. You can download the report or dataset (.pbix file) from the Power BI service to Power BI Desktop, add this new data source and append new data to the existing table. After that, apply the changes to load data to the data model. Publish the .pbix file to Power BI Service to replace the existing dataset and report there. Go to dataset settings page and edit credentials for the new data source.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
3 Replies
How is the Jan-May data done? In 5 Excel files, or 1? If 1, is it 5 tables or 1?
Ideally it would be 5 files, and now 6 with June.
Bottom line is you want to bring this into the model using the APPEND function of Power Query as it will just add the JUNE, (then July, Aug, etc) on the next refresh. But there are about 20 ways to do this depending on how your source data is stored. The following article will explain how to combine files (CSV, XLSX, and even PDF) to give you an idea, but we need a lot more info from you to help set this up so you never do any work on this again. You just add files to a folder, refresh, and data is updated.
Combine files (binaries) in Power BI Desktop - Power BI | Microsoft DocsHow to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.Yes , The raw data is taken form online website from Jan to may as 1 file.it has 2tables but we append together to make it as 1. Now I have to do same , I have to download June date from site then I have to do data cleaning then I have to pull to powerbi.
Hi AtchayaP
A report can be created using data from only one dataset. Power BI Desktop can combine more than one data source into a single dataset in a report, and that report can be imported into Power BI Service. However, Power BI Service cannot add new data sources to an existing dataset.
Since you want to add June data from a new file, you need to use Power BI Desktop. You can download the report or dataset (.pbix file) from the Power BI service to Power BI Desktop, add this new data source and append new data to the existing table. After that, apply the changes to load data to the data model. Publish the .pbix file to Power BI Service to replace the existing dataset and report there. Go to dataset settings page and edit credentials for the new data source.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
