search

bhavesh-jadav / Power-BI-Theme-Generator

Tool for generating theme from Power BI file
GNU General Public License v3.0
8 stars 2 forks source link

Error when opening PBIX file #6

Open YoungRickyDiaz opened 5 years ago

YoungRickyDiaz commented 5 years ago

Hi, I'm new to Python so this error may be due to me installing something incorrectly, or not running it correctly...

I have installed Python 3.7 64-bit on my Win10 Laptop. I have then installed all the components using pip install [componentName] untill all were installed.

Next, I opened PowerBIThemeGeneratorGUI.py in the Python IDLE 3.7 window, then used F5 to Run the module. The GUI opened and I used the file menu to select my pbix file. After that, this error appeared.

ERROR:root:string index out of range Traceback (most recent call last): File "C:\PowerBI\Power-BI-Theme-Generator-master\Power-BI-Theme-Generator-master\src\main\python\PowerBIThemeGenerator.py", line 153, in _fixPropertyValue if value[-1] in ['L', 'D'] and value[0] != '#': IndexError: string index out of range

Are you able to help here? I am trying to extract the theme from a current report so I can build a universal theme file for use on other reports. Many thanks, Rick

bhavesh-jadav commented 5 years ago

You can directly download .exe file from https://github.com/bhavesh-jadav/Power-BI-Theme-Generator/releases under assets. You don't have to download code and run yourself instead you can directly used .exe file

Will you be able to share your pbix file? I am asking for pbix file because sometimes Power BI stores format data differently hence I need pbix file to cover special cases (that your pbix file might have) that I have not cover in my code.

YoungRickyDiaz commented 5 years ago

Hi Bhavesh, Thanks for the quick response! I'll take a look at the exe now as that will be extremely useful. With regards to the pbix, I'm afraid I can't share this one as it contains confidential data (I am currently working for the police). On the plus side, after the error occurs, the GUI then works correctly and extracts the theme JSON. For this, I'm extremely grateful!

bhavesh-jadav commented 5 years ago

I am glad it is working for you.