didierterrien / Power-BI-Sidetools

Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop.
69 stars 7 forks source link

After running 'PBI to files' none of the files were populated #11

Closed rhartopAW closed 3 years ago

rhartopAW commented 3 years ago

After running 'PBI to files' none of the files were populated and the log reported this error:

=== V1.2.0.0 ====================== [04-26-2021 14:11:20] Folders initialised [04-26-2021 14:11:21] Power BI file name identified [04-26-2021 14:11:21] Check updated version error : Index was outside the bounds of the array. [04-26-2021 14:11:22] Connected [04-26-2021 14:11:22] Initialisation completed [04-26-2021 14:15:17] Connected [04-26-2021 14:18:02] Connected [04-26-2021 14:19:47] End === V1.2.0.0 ====================== [04-26-2021 14:21:45] Folders initialised [04-26-2021 14:21:46] Power BI file name identified [04-26-2021 14:21:46] Check updated version error : Index was outside the bounds of the array. [04-26-2021 14:21:46] Connected [04-26-2021 14:21:46] Initialisation completed [04-26-2021 14:21:49] Connected [04-26-2021 14:34:34] End

The folder was located in my Documents folder, unconnected to OneDrive. Will try and look into further if I get the time.

didierterrien commented 3 years ago

Hello, Thank you for the feedback. The error in the log file is not connected to PBI to files feature. Did you change any setting ? I suppose there is a "Power BI Sidetools" folder in your "Documents" folder because you could open the log file. Is there any special character in the .Pbix file ?

rhartopAW commented 3 years ago

There is no special characters in the MDM (that I am aware of). No settings were changed. The software was installed and immediately used. I did click open VSCode before clicking 'PBIX to files' accidentally, though doubt this will be causing an issue.

The PBIX is large - around 160 datasets with about 150 measures. Am unsure if this breaks the constraints of an array?

I will try again later.

didierterrien commented 3 years ago

Opening VS code first has probably no impact. Can you confirm the folder "Documents\Power BI Sidetools" doesn't contain any folder ? Is your model in the pbix file or do you use a live connection ? Your model isn't so big. Can you try with a smaller model ? If it works, can you share your .pbix ?

didierterrien commented 3 years ago

I improved file access error detection in version 1.2.1 published today. Please update and let me know if it helps. By the way I renamed the issue. "Index was outside the bounds of the array" was linked to the update detection (corrected in version 1.2.1)

didierterrien commented 3 years ago

I close the issue but feel free to reopen it if necessary.