Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello Community,
I installed the Scanner API from Tommy Puglio like in this video.
Unfortunately the Scanner API (JSON File) doesn´t show tables when the load in Power Query is disabled. My Power BI Modell has 3 areas for tables. Staging, Transforming and Reporting. Only the Reporting tables are loaded. Staging and Transforming are disabled. But I need the source.expression from the Staging tables. Do you have a solution for this use case?
Modell in PQ:
Result from Scanner API:
is:
Best regards Marcus
I have the same issue, did you find a solution to fetch the load disabled tables as well?
Hi Elias,
I did a workaround. When it was possible I connected the staging tables as direct query and hide them. Then I switched the referenced tables to import Mode.
When you have datasources that only works with import Mode you have to load both tables, staging and reporting and hide the staging tables.
Unfortunately I have No better way.
Best regards
Marcus
Hi @Anonymous ,
thanks for your reply. I've read the article about the limitations but I couldn't find a answer to my question. There is nothing to read about tables that are disabled.
I still hope there is a way or another Rest API which can GET all Tables from a dataset independently of whether 'Enable Load' for tables is activated or disabled.
Best regards
Marcus
Hi @PowerSchmiede ,
I think you may refer to this offical blog about considerations and limitations when getting data by Scanner API.
For reference: Considerations and limitations
I hope it could help you solve your issue.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
6 | |
4 | |
2 | |
2 |
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |