New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

dbachecks.pbix is corrupt or an invalid report file #544

Open
francescovista opened this Issue Sep 5, 2018 · 4 comments

Comments

Projects
None yet
3 participants
@francescovista
Copy link

francescovista commented Sep 5, 2018

Bug Report

General Troubleshooting steps

run:
Invoke-DbcCheck -SqlInstance sql2017 -Checks SuspectPage, LastBackup -Show Summary -PassThru | Update-DbcPowerBiDataSource
run:
Start-DbcPowerBi

filesarethere

Version Information

Operating System (Name|Version): Windows 10 Enterprise
PowerShell Version:

Major  Minor  Build  Revision
-----  -----  -----  --------
5      1      15063  1155

SQL Server (Edition|Version):
Microsoft SQL Server Management Studio 13.0.16106.4
Microsoft Analysis Services Client Tools 13.0.1700.441
Microsoft Data Access Components (MDAC) 10.0.15063.0
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.15063.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.15063

Steps to Reproduce

run:
Invoke-DbcCheck -SqlInstance sql2017 -Checks SuspectPage, LastBackup -Show Summary -PassThru | Update-DbcPowerBiDataSource
run:
Start-DbcPowerBi

Description of Bug

before running the first command with -SqlInstance localhost I run the command that I copied form your page:

Invoke-DbcCheck -SqlInstance sql2017 -Checks SuspectPage, LastBackup -Show Summary -PassThru | Update-DbcPowerBiDataSource

before

I think the data were loaded and maybe they are corrupted. You should put a check that watch out id that instance exists or if the data are alright

@SQLDBAWithABeard

This comment has been minimized.

Copy link
Collaborator

SQLDBAWithABeard commented Sep 6, 2018

HI @francescovista Please try copying the pbix from

C:\Program Files\WindowsPowerShell\Modules\dbachecks\1.1.151\bin

to

AppData\Local\dbachecks

The version I have from the gallery is working correctly

@francescovista

This comment has been minimized.

Copy link

francescovista commented Sep 6, 2018

I copied the pbix from "C:\Program Files\WindowsPowerShell\Modules\dbachecks\1.1.151\bin" to "AppData\Local\dbachecks" but when I double click on it:

downloaded

So I downloaded a fresh new repository from GitHub and I copied the pbix from there, as you can see the date has changed from 05/09/2018 to 06/09/2018, so is your latest from yesterday but still no joy:

datechanged

So I fired up Power BI, version Version: 2.61.5192.601 64-bit (August 2018) and I opened the fresh new version downloaded 10 minutes ago:

errors

the logs are in attach

DetailsError.txt

@SQLDBAWithABeard

This comment has been minimized.

Copy link
Collaborator

SQLDBAWithABeard commented Sep 7, 2018

Excellent, does that mean it is now working for you?

@LowlyDBA

This comment has been minimized.

Copy link
Contributor

LowlyDBA commented Oct 10, 2018

I've been experiencing this issue with a lot of my users.. when I upgraded my PowerBI version (thanks to the not so subtle prompts every time I open it) and save the report, it breaks backwards compatibility. It was also the August update, not sure if this happens with every monthly update or not..

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment