Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Franck_ecocert
Frequent Visitor

Use an excel file (in a workspace) as a source

Hello,

 

I'm not sure this is the right place to post my question but I can't decide where it's better.

 

I load an excel file in premium workspace and I wonder if it's possible to use it as a source in a dataset ?

I konw there is other ways to integrate an Excel file into Datasets.

 

Regards

 

Franck

 

 

1 ACCEPTED SOLUTION
Franck_ecocert
Frequent Visitor

OK I understand this is not currently possible with PowerBI.

So I store my Excel in a sharepoint folder to use it as source.

View solution in original post

3 REPLIES 3
Franck_ecocert
Frequent Visitor

OK I understand this is not currently possible with PowerBI.

So I store my Excel in a sharepoint folder to use it as source.

v-luwang-msft
Community Support
Community Support

Hi @Franck_ecocert ,

What you mentioned is not recommended.Using Power bi dataset is not recommended because it is live connection mode. The best way is once you open a excel in Workbook, You can just select the table and copy and past to "Enter Data" in Power bi desktop.

And the upload option will one let you show the sheet but not cleaning. If you want to clean you have to do it in the OneDrive Excel or in Power Bi Desktop. You can't use Power Bi Service for cleaning as I have mentioned before. It's only for creating visualizations or read reports.

 

Similar case refer:

https://community.powerbi.com/t5/Service/Can-a-uploaded-Excel-be-used-as-a-source-in-a-PBI-report/m-... 

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

amitchandak
Super User
Super User

@Franck_ecocert , Create a data flow, there is an option to upload excel in excel source.

Then you can use that data flow in power bi file and create data source.

 

But that can make excel static unless you define how to refresh

 

Add a file to power bi file, Create a model and publish. Use the dataset of this file as dataset for other reports

You can use on premise gateway to refresh

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.