topic Power BI Scanner API didn't get 'disable load' tables in Developer

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

PowerSchmiede — Tue, 06 Sep 2022 11:32:40 GMT

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

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

Anonymous — Wed, 07 Sep 2022 09:33:08 GMT

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.

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

PowerSchmiede — Thu, 08 Sep 2022 12:32:44 GMT

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

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

Eliasaki92 — Mon, 17 Apr 2023 16:32:43 GMT

I have the same issue, did you find a solution to fetch the load disabled tables as well?

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

PowerSchmiede — Mon, 17 Apr 2023 18:44:55 GMT

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