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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DigDeeply
Frequent Visitor

"there is no available gateway" confusion

Hello

I have a report I authored in Desktop that references data in Azure SQL Server (mostly Direct Query, smaller tables are Local Import), and have successfully distributed the report to colleagues via a Workspace.

I wish to add a reference table to the report that is in an xlsx flat file. It's just a list of dates and numbers. It can be packaged with the report and won't need to be refreshed.

 

In Desktop I imported the file in 'Local Import' mode, it works fine in the report.

I publish the report to Service (app.powerbi.com) and upon checking I see 'There is no available gateway' error. I was expecting the data to be  embedded in the report so I don't understand the need for this. I see no need for a gateway and don't require the Service to attempt to reload local data. A one time 'embed' is sufficient.

As a second attempt I used Service to create a new Dataset and uploaded and loaded the xlsx to that. But in this case when I review the list of available Datasets in Desktop, the newly created Dataset is not available, despite waiting for some time.

I'd appreciate pointers on what I am doing wrong or a link to the relevant documentation please. Searches haven't helped.

Many thanks.

Update: worth mentioning that in Service, the preview of the table loaded from the xlsx looks valid. I've now confirmed this with a download from Service.

3 REPLIES 3
Wikkleyn81
New Member

Hi @DigDeeply Unselect Include in Report Refresh. This will remove the requirement of a gateway. But if you need to make a change, you will have to reload and publish the dataset. Rather save the document to a cloud source e.g. SharePoint/OneDrive. That will enable you to load from the xlsx file and if you make changes it will automatically be included. 

 

Wikkleyn81_0-1688569002375.png

 

GilbertQ
Super User
Super User

Hi @DigDeeply 

 

For it it to be refreshed you need to store the file on a file system or ideally SharePoint online and then connect to the Excel file from Excel online. Once that is done you will then get the option to refresh





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

Proud to be a Super User!







Power BI Blog

Thank you Gilbert yes I understand that. Is it not possible simply to embed the small data file into the pbix for it is 'fixed' an no refresh is needed?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors