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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Is their any possible to view report if gateway fails

Hi Team,

Is their any possible to view report if gateway fails, if yes please guide me how to get it done.

Thanks

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

9 REPLIES 9
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

v-luwang-msft
Community Support
Community Support

Hi  @Anonymous ,

This needs to be discussed on a case-by-case basis, depending on how your data source is connected.

Import :You can still view the old data, a gateway failure will prevent the report from updating with new data, but will not affect your ability to view the old data.

Power BI imports the data from the original data sources into the dataset. Power BI report and dashboard queries submitted to the dataset return results from the imported tables and columns. You might consider such a dataset a point-in-time copy. Because Power BI copies the data, you must refresh the dataset to fetch changes from the underlying data sources.

Direct Query &Live Connection:When you are interacting with a report, you cannot view the report because when both modes are used, there is a real-time query to the database, which requires a gateway. For example, after the gateway fails, I go to reopen a report with a direct query connection, and when I open it, it triggers a request that is sent to the data source through the gateway, and because the gateway fails, this report cannot be viewed at this time.

Power BI does not import data over connections that operate in DirectQuery/LiveConnect mode. Instead, the dataset returns results from the underlying data source whenever a report or dashboard queries the dataset. Power BI transforms and forwards the queries to the data source.

 

To learn more details,refer:https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data 

 

Wish it is helpful for you!

 

Best Regards

Lucien

aj1973
Community Champion
Community Champion

Hi @Anonymous 

The Gateway function is to connect and refresh the report from the source, that's it.

So if you published the report with the visuals you developped and the Gateway is failling then the data stays as is and it doesn't break the report.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

Thanks for quick response. Could you please expalin in details am new to Power BI

aj1973
Community Champion
Community Champion

@Anonymous 

Of course but what else to explain? what do you want to know?

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

if you have any refrence documents or links please share with me

aj1973
Community Champion
Community Champion

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks for confirming my response @aj1973 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Pragati11
Super User
Super User

Hi @Anonymous ,

 

I am in sure in Power BI service, if you go to your report, you will able to see it with the old data as the Power BI gateway failed.

Login to Power BI service and go to the workspace where the report was published.

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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