Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I have a PBI reports reading data both from Web API and local static data from excel and JSON files. When I published and tried to Schedule a refresh on this report. The local files are giving me error!
1. Is there a way to stop the refresh for those files that have statis data? So that the refresh doest not give error?
2. if for the above first question the answer is no. I tried to upload the excel and JSON on oneDrive. Excel files are visible on OneDrive however JSON are not!
3. Can I use Gateway for those local file?
Solved! Go to Solution.
Kindly set up the gateway for the dataset:
https://docs.microsoft.com/en-us/power-bi/service-gateway-getting-started
https://docs.microsoft.com/en-us/power-bi/service-gateway-install
https://docs.microsoft.com/en-us/power-bi/service-gateway-manage
And make sure ticked the option:
Kindly set up the gateway for the dataset:
https://docs.microsoft.com/en-us/power-bi/service-gateway-getting-started
https://docs.microsoft.com/en-us/power-bi/service-gateway-install
https://docs.microsoft.com/en-us/power-bi/service-gateway-manage
And make sure ticked the option:
To avoid the hassle of a gateway, the best is to put your Excel and JSON in the cloud (Sharepoint or OneDrive). I did a quick test with a JSON file and was able to see it when I connected to OneDrive with the SharePoint Folder connector. Have you tried that?
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hello,
thank you for your answer, actually i uploaded on OneDrive both XLS and JSON files. However, when I used the "Share Point" collector folder, i wasnt able to view / see the JSON files for some reason! Eventually, I removed the tables reading from JSON since I forgot that I had used MAPBOX and I do not need those files! however, I am sure one day in future i will encounter the same scenario.... and dunno how to solve it!
Hi @RaffiKouzoudj ,
3. Yes, you can use a gateway for local files.
Take a look at this too.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi @RaffiKouzoudj ,
try to disable the "Include in report refresh" option.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi Wegener,
thank you for your reply, I tried that option and diabled "Include in report refresh" and it continued refreshing and gave error.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |