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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JMAN23
New Member

Local data upload

Hi, I cannot get my local file uploaded in Power BI professional services. This was working fine till last month. No error messages shown. Just seems upload finishes but data are not really loaded, even clicking on data refresh.

Any idea why? Thanks

1 ACCEPTED SOLUTION

@JMAN23,

Why not directly adding excel source with gateway and schedule refresh for the dataset? This way, you don't have to import the local file each month when you have data change in Excel file.

In addition, do you make change to columns(rename columns, add new columns) in Excel file?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Employee
Employee

@JMAN23,

What type of file do you upload to Power BI Service? Where do you connect "data refresh"? Do you configure gateway from this data source?

In addition, please use Power BI Desktop to connect to this file and check if you get any issues.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

Thank you very much for your response.

 

Actually, I'm using Power BI Pro through my professional Office 365 account. I cannot install Power BI Desktop due to laptop administraion restrictions.

Since last year, I import on a monthly basis a local excel file to the dashboard in Power BI.

The steps a follow are:

  1. Get Data
  2. Files/Get
  3. Local file
  4. Selection of the local file
  5. Import
  6. Message 'A dataset with the same name exists' --> Replace it

This has worked everytime for many months. However, now nothing happens.

The dashboard keeps showing the previous data not showing the new data from the local file.

 

I tried the Upload option instead of Import on setp 5. On this case, the local file is uploaded as a workbook correctly. But I don't know how to link the existing dashboard to the workbook.

 

By the way, my Pro trail is 22 days left, just in case this is somethig related.

 

I appreciate so much your support.

 

Regards

J

@JMAN23,

Why not directly adding excel source with gateway and schedule refresh for the dataset? This way, you don't have to import the local file each month when you have data change in Excel file.

In addition, do you make change to columns(rename columns, add new columns) in Excel file?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I will try it.

Thank you very much.

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors