Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Direction on managing multiple datasets

Hello all,   I am pretty new to PBI. I have been working with it long enough to make some decent reports but I am running into an issue now. I am trying to figure out the best way to manage and sha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the response healthEteam. I'll check out the append feature. I would worry about the size of the report though if I combined each dataset into one. Right now with just one report with one dataset it takes roughly 1-2 mins to refresh all the data when manually refreshing. I'm still having trouble with the scheduled refresh so I have not done that yet but I imagine it would be similar. Each dataset source I'm pulling from is roughly 1-2MB with multiple excel tables from multiple workbooks. The .PBIX report file itself, again with just one of those datasets, is about 1MB too for reference. If I combined all 10 locations I worry that size might go up to 10-15MB.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

I'd like to suggest you create a template pbix report with visuals which you wanted and parametrize connection string as query parameters.

Deep Dive into Query Parameters and Power BI Templates

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,

 

Then you can simply use that template to generate multiple reports with different connection parameters.

 

BTW, power bi not support store multiple sharepoint credentials at same report, the old one will been replace when you signed in new credentials.

 

Regards,

Xiaoxin Sheng