Forum Discussion

JWA___'s avatar
JWA___
Regular Visitor
3 years ago

Bulk update M code in Power Query

Hi   I have a dataset with many facts and dimensions pointing to a Synapse SQL database. The data is moved to Azure Databricks, which means I need to update all my PQ queries. This is not a matter...
Need Help
jsanchezm's avatar
jsanchezm
Frequent Visitor
3 years ago

With the new Developer Mode you can export all your pbix to pbib (and its folders) and each model.bim file contains the definition of the source of your query's data. Using some tool (don't know how to do that in Windows) you should be able to update all the strings at once. Then you can save once again the pbib project to pbix and republish it.

JWA___'s avatar
JWA___
Regular Visitor
3 years ago

This sounds interesting and hopeful! ...but goes beyond my current knowledge. I am not familiar with Developer Mode pbib files. Have heard of bim files, but not sure how to get these or what to do with it, etc.

Would you mind to elaborate or alternatively share some blogs or YT videos that explain more step by step how to do this, please?

Thanks!

  • jsanchezm's avatar
    jsanchezm
    Frequent Visitor
    3 years ago

    Here you can start digging: Power BI Desktop developer mode documentation - Power BI | Microsoft Learn

    Most of the files, including the .bim ones, are plain text so you don't need any special tool to edit them. We can't publish the pbib projects to the service yet, although I've seen some insider comments saying that it will be possible in not a too far future, but today we still have to first resave it to pbix.