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
Hi Team,
Is their any possible to view report if gateway fails, if yes please guide me how to get it done.
Thanks
Solved! Go to Solution.
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
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
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
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
Thanks for quick response. Could you please expalin in details am new to Power BI
@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
if you have any refrence documents or links please share with me
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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |