Relative Content

Tag Archive for pythonpowerbi

In Power BI, when I get data by Python script, it keep shows this error

Details: “ADO.NET: Python script error.
Traceback (most recent call last):
File “C:Users####PythonScriptWrapper_ddec053d-7bfc-4f27-8ea3-03d81d9a6c40PythonScriptWrapper.PY”, line 2, in
import os, pandas, matplotlib
File “C:Users####anaconda3libsite-packagespandas_init_.py”, line 22, in
from pandas.compat import (
File “C:Users####anaconda3libsite-packagespandascompat_init_.py”, line 15, in
from pandas.compat.numpy import (
File “C:Users####anaconda3libsite-packagespandascompatnumpy_init_.py”, line 7, in
from pandas.util.version import Version
File “C:Users####anaconda3libsite-packagespandasutil_init_.py”, line 1, in
from pandas.util._decorators import ( # noqa
File “C:Users####anaconda3libsite-packagespandasutil_decorators.py”, line 14, in
from pandas.libs.properties import cache_readonly # noqa
File “C:Users####anaconda3libsite-packagespandas_libs_init
.py”, line 13, in
from pandas._libs.interval import Interval
File “pandas_libsinterval.pyx”, line 1, in init pandas._libs.interval
ValueError: numpy.dtype size changed, may indicate binary incompatibility. Expected 96 from C header, got 88 from PyObject

dynamic table comparison in powerBi

Problem – I have loaded multiple csvs in the PowerBI, These csvs columns are Filename, Mileage, City, Time etc. Multiple csvs have the similar information with little changes in terms of additional mileage, city and Time. Filenames should ideally be same but it may happen that some csvs have less rows and some have more.
I want to add 2 slicers in the dashboard for csvs version(V1, V2, V3 etc) and based on the selection in these slicer i want to compare 2 selected csv values for similar Filenames, what is the mileage and in which city and time the files are connected to.

Integrating Custom Python Environment with Power BI Service

I’ve created a chart using python and pipenv. I want to integrate this chart into my company’s main PowerBI environment. I’ve read that I can use python scripts within PowerBI Desktop, as long as I provide a path to a local python installation.

PowerBI python environment configuration

I’ve created a chart using python and pipenv. I want to integrate this chart into my company’s main PowerBI environment. I’ve read that I can use python scripts within PowerBI Desktop, as long as I provide a path to a local python installation.

How to set isActive for different reports in PowerBI?

I have multiple pages in my report. I am trying to set inactive pages in my report as active in order to validate the summarized data for each report.
Tried multiple ways to call reports with isActive False and set it to true using below: