Hi, I need some guidelines on preparing power BI (PBIX) file to plug into CD pipelines. Have a few questions. Hopefully someone can help to guide.
- What’s the prefer way to set connection string? In our case, source database = SQL. Saw MSFT blog post to use parameters for this. If not parameters, any alternative ?
- what’s the best way to empty out dataset (data import) PBIX before checking into source control? This way, the CD script will deploy the (small file) PBIX to correct workspace and perform full data refresh after setting connection string property/parameters.
Any comments greatly appreciated.