Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
If the PBI report is based on multiple data source then what could be the method for schedule refresh to work on the web service if other excel data source is broken or fail to refresh?
Appreciate your ideas!
Thank you,
Hi,
Please paste the Advanced editor code on a blank query, This might be help.
If my answer helps, please accept the solution.
Regards 🙂
let
Path = "C:\Users\TR100722\Desktop\powerbi\Form.xlsx",
Result = try Binary.ToText(File.Contents(Path)),
Output =if Logical.From(Result[HasError]) then "not exist" else Excel.Workbook(File.Contents("C:\Users\TR100722\Desktop\powerbi\Form.xlsx"), null, true)
in
Output
@DeoYadav Depends, you can refer to this: Dealing with errors - Power Query | Microsoft Learn. You could, for example, add a step or multiple steps that removes all errors in all columns. Thus, if there was an error involving data then this would not impact the loading of the table (it would likely load as a blank table for example) but not result in an error that would affect the other queries potentially. However, it is doubtful that the report would end up with valid information anyway.
@Greg_Deckler thank you for sharing, will go through it and try if it works for me. in my case, I'm using excel data on the cloud and other data sources too.
thank you.
Hello,
You should use a data gateway if you have a data source that is on premises not on cloud, and you should setup the data gateway in the service. Also the server which has the datasets should be turned On when the data is refreshing.
Here is a link on data gateway https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |