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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
masplin
Impactful Individual
Impactful Individual

Refresh on Demand no longer working

Hi. I have 2 excel 2016 work books with powerpviot models saved in the same folder on Sharepoint.  I conencted them up to Power BI and built a bunch of reports that all worked perfectly and for the last few weeks have been refeshing fine. I rightclick on each dataset and press refesh now and all good as long as the excel workbooks are closed.

 

Then a few days ago one of them suddenly changes and if I got to datasets/setting I no longer see the gateway. The list starts at OneDrive Refresh. So below are the 2 different settings

 

Capture.PNGINO NAV.PNG

When I try to do a refresh on NAV Model I get this error 

 

Capture.PNG

 

If I open the workbook and refresh the data in the workbook and save and close then I get that data in power BI. 

 

Any clues what has gone wrong would be appreciated

 

Mike

1 ACCEPTED SOLUTION
masplin
Impactful Individual
Impactful Individual

Hi Idont think you are correct.  I have a free licence as it says 1GB space. I have 2 datasets both pointing att he same source. One refeshes and the other doesnt.

 

I wound back a few versions and now get at least the gateway showing.. Now i have adiffernet issue os wil lstart a new thread.

 

Compelte mystery why this issue happened.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

Hi @masplin,

 

Which type of datasource you connect in excel file? Based on your error message, it seems like you connect to an unsupported data source.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
masplin
Impactful Individual
Impactful Individual

Well both models conenc tot he same data source!!!  Its an sql database.  The only differnece s the one that works links ot 1 table the one that doesnt to several table (on the same DB). However  this structure hasnt changed for weeks and it was working a week ago and suddenly isn't. 

Hi @masplin,

 

Which license you use, free trial or pro?  Current data gateway only support for pro license.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
masplin
Impactful Individual
Impactful Individual

Hi Idont think you are correct.  I have a free licence as it says 1GB space. I have 2 datasets both pointing att he same source. One refeshes and the other doesnt.

 

I wound back a few versions and now get at least the gateway showing.. Now i have adiffernet issue os wil lstart a new thread.

 

Compelte mystery why this issue happened.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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