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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors