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

Join 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.

Reply
PowerSchmiede
Frequent Visitor

Power BI Scanner API didn't get 'disable load' tables

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:

PowerSchmiede_1-1662463327455.png

Result from Scanner API: 

PowerSchmiede_2-1662463344015.png

is:

PowerSchmiede_3-1662463568101.png

 

Best regards Marcus

4 REPLIES 4
Eliasaki92
Advocate II
Advocate II

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

PowerSchmiede
Frequent Visitor

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 

Anonymous
Not applicable

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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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