Get name of all pages in power bi desktop using DAX/PowerQuery/M

[Anonymous]

HI I have 35 pages in my desktop pbi.

I would like a way to automatically extract the names of the pages, so that I can create a slicer to use as a navigation.

Is there a way (using DAX or power query or M) to detect that names of all pages, and make a new table? Currently, I manually copy and paste each page name into a separate file, and would like to avoid this, as it is very manual

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

Currently in Powerbi Desktop, navigation can only be created by manually entering the name of the page. I did a test, the reference is as follows:

reference blog link:Dynamic Page Navigation using slicer in Power BI - SqlSkull

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt of any such way. You may check power bi Rest API and using that push into a table use that https://docs.microsoft.com/en-us/rest/api/power-bi/