New Idea
0 Kudos

Salesforce object DataSource.Error

Status: Needs Info
by Ronald_01 Frequent Visitor on ‎03-17-2017 06:18 AM

Hello,

 

I experience problems with the connection to one of my objects in salesforce. 9 out of 10 work perfectly but this one I can not load into my datamodel. I receive the following error:

 

 

DataSource.Error: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 </head>
 <body>
  <center>
   <table bgcolor="white" style="align: center;">
    <tbody>
     <tr><td><br><br></td></tr>
     <tr>

      <td>
       <table bgcolor="white" cellpadding="0" cellspacing="0" style="border:1px solid #ccc;" width="758">
        <tbody>
         <tr><td><br></td></tr>
         <tr>
          <td>
           <div style="background-color: white; border: 1px solid #ccc; padding: 0px; margin-top: 10px; margin-bottom: 0px; margin-left: 10px; margin-right: 10px;">
            <table bgcolor="white" cellpadding="0" cellspacing="0" width="758">
             <tbody>

              <tr>
               <td><span style="font-family: Verdana; font-size: medium; font-weight: bold;">We are down for maintenance.</span><br><br>Sorry for the inconvenience. We'll be back shortly.</td>
              </tr>
             </tbody>
            </table>
           </div>

          </td>
         </tr>
         <tr>
          <td>
           <span>
            <table border="0" cellpadding="0" cellspacing="0" style="text-align: right;" width="100%">
             <tbody>
              <tr>
               <td>

                <span>
                 <span style="font-family: Verdana; font-size: smaller">Powered by <a href="http://force.com">force.com</a></span>
                </span>
               </td>
              </tr>
             </tbody>
            </table>

           </span>
          </td>
         </tr>
        </tbody>
       </table>      
      </td>
     </tr>
     <tr><td><br></td></tr>
     <tr><td></td></tr>

     <tr><td><br></td></tr>
    </tbody>
   </table>
  </center>
  <!--  Served by force.com -->
 </body>
</html> 
<!-- Generated Fri, 17 Mar 2017 13:02:58 GMT (scl) -->

 

Could you please help me out?

Kind regards,

Ronald

 

Status: Needs Info
0 Kudos

Hello!
I installed, configured, and linked the database to my on-premisses gateway.

imagem 1.png
But when I try to schedule the update of my datasets, the program does not allow me to select the data gateway (even though it's online).
How can I enable on-premisses data gateway selection?

imagem 2.png

Regards,
Thomaz

Status: Accepted
0 Kudos

I have a PIBX that uses two different on premises SharePoint lists, a SQL Server database and an on prem AD link. I have installed the personal data gateway to do a manual refresh. Before Xmas, everything was working fine.  My PC was turned off for a few days over the holidays and today I tried to restart the personal gateway without success (not responding), so I uninstalled and re-installed it. Now I can't enter the credentials to one of the SharePoint lists. In the Settings page for the Dataset I get the error that the credentials are invalid. When I enter them again with Windows auth, I get the error that the site can't be reached (http 400), but the site is up and running. 

 

I can refresh fine with the desktop app and upload the PIBX, so the data connections are valid and authentication is fine.

 

Just not in the personal gateway.

 

How can I repair the corrupt data connection?

GatewayError.png

 

 

Status: Needs Info

Web Data Refresh Error

Status: New
by rdoughty Occasional Visitor on ‎11-15-2016 12:23 PM

Hello Power BI community,

I recently created a desktop file and with "Web" as the only data source. Everything was working great. After a week, the refresh failed. It appears Power BI thinks I am trying to use an on premise data source and as far as I know the "Web" feed can be refreshed without a gateway. (Like I said, it was working wonderfully for a week.) Could anyone offer some suggestions? I have tried renaming, republishing, deleteing... I have made a new .pbix and published it from scratch with the same result. Any help is much appreciated!

Thanks, Ryan.

0 Kudos

Power BI Service Random Gateway Connection Change

Status: Needs Info
by mhasanbulli Regular Visitor ‎03-19-2017 06:02 PM - edited ‎03-19-2017 06:19 PM

Hi,

 

I have some reports in Power BI Service that their source is Azure SQL Database. These reports have been refreshing from their source just fine.

 

We have gained a new customer and I have set up an on-premises data gateway for them. Gateway has been installed on their server. Because we are doing some testing, I have added the data source in my Power BI Service. Suddenly all of my existing reports' gateway source switched to a personal gateway I have installed and tested months ago. I do not have this gateway anymore, neither on my PC nor on Gateways section in Power BI. None of the existing reports used this old connection. 

 

Why do they randomly switch to something that does not even exist? This is extremely frustrating. How come an Azure SQL source can suddenly switch to a personal gateway that is not there? 

 

How do we solve issues like this one?

Status: Needs Info
0 Kudos

Every time I share a dashboard with a new user it throws up an error.

 

It says the user does not have access to the dashboard.

 

They need to log off and log on again.

 

Seriously guys - please fix these annoying bugs.

 

 

0 Kudos

I have Power BI Online reporting connected to Azure Analysis services, and there are sporadic times that datasets, reports, and dashboards won't automatically refresh at their expected intervals. In most cases the Power BI online reports and dashboards are 2 hours behind in refreshing.

The datasets are all connected live. I have a screenshot example of 4 datasets where the "Next Refresh" date/time is prior to the current date/time.

Is there anything that can be done to automatically force dataset/report/dashboard refreshes (PowerShell Script, Azure Function, etc...), or are there any dataset settings that need special configuration?

I have also posted this issue on the MSDN forums, and received a response confirming the behavior in the test environment. The URL of the posting is https://social.msdn.microsoft.com/Forums/en-US/44e770e6-d919-4863-baaa-6ef4b81787bc/analysis-service...

 

PBI.PNG

Status: Delivered

Invalid credentials on Sharepoint folder

Status: Accepted
by csabil Frequent Visitor on ‎11-22-2016 10:46 PM

Since yesterday I'm having an issue connecting to an excel file in a Sharepoint folder. It was already working, but I made some changes and republished it. Refresh works fine in Power BI Desktop, but online. It seem it's trying to connect to a Sharepoint list, instead of folder. I have an other report connecting to an other excel file in the same folder and it works fine. Could this be connected to the issue in North Europe? I'm in that datacenter.

 

Capture.PNG

Status: Accepted
0 Kudos

SSAS Live Connection Refresh

Status: New
by wmorris20 Regular Visitor on ‎12-13-2016 02:13 PM

We have an enterprise data gateway succesfully setup with live connections to SQL Server, SSAS MD, and SSAS Tab.  When viewing the refresh history, it shows that the refreshes are happening roughly every 30 minutes; however, the documentation I have read makes it sound to me like the data should refresh on interaction.  Is there a configuration in the data source or on-premise data gateway that defines that update frequency?  Or is this a configuration that is controlled by Microsoft?

 

Please see http://community.powerbi.com/t5/Service/Connect-Live-SSAS-Update-Frequency/m-p/101926 for more discussion.

0 Kudos

Gateway falls over every other day!

Status: Needs Info
by jak82 Member on ‎01-24-2017 12:44 AM

We have managers accessing direct query to view live figures using PowerBI after moving away from our old system.  What we are finding out though is that the enterprise gateway keeps falling over.  

 

This is MISSION CRITICAL as it is on a new server and manager use it to access live figures using Direct Query.  There is also no notification it goes down other than managers calling in saying they cant access figures.

Status: Needs Info
0 Kudos
I have posted a dataset/dashboard to our PowerBI Environment in a shared group. In the dataset settings it says "This dataset has been configured by xxx.xxxxxx@gmail.com. Why is this showing my personal gmail account rather than my powerBI account that I am signed in as. Gmail accounts aren't even allowed in for powerbi accounts so how did this even happen?
0 Kudos

Hi,

 

We have a Windows Server 2012R2 box up in azure running MS SQL server - I have managed to install the enterprise gateway fine and can access the SQL DB fine with PowerBI Desktop, but when I am trying to add a new data source within office 365 I get the following error:

 

powerbi problem.jpg

 

I have set up data sources from servers in our own DC fine, just never when MS SQL is on a server up in azure, any suggestions?

 

Status: Needs Info
0 Kudos

Data source connection Issue

Status: New
by kadee15 Frequent Visitor on ‎12-19-2016 04:46 AM

Hi, I have been using Power BI Desktop without any problem until now, a few days ago i connect to my Azure database but now when i try to connect and load my table in Power BI i receive this error. "Unexpected error: The specified key does not have a valid size for this algorithm."

I googled so much but any solution found. Please help! Other mates can connect and use the same data but i receive this message. Reinstall PowerBi doesnt resolve the problem.

Thank you. Oscar.

0 Kudos

Losing access to dashboards

Status: Delivered
by tsg_kevin Frequent Visitor on ‎11-21-2016 10:30 AM

The site is giving me an error:

 

[Dashboard] contains Power BI Pro content

 

the reports datasets are all hosting on my OneDrive Business. (An Excel workbook accessed via the web url)

 

I thought that was an issue since I recently put some data on the cloud. But older dashboards that didn't have an issue with now does. 

 

Was there a change to the service recently such that any on-prem data including OneDrive needs the personal gateway and Power BI Pro?

 

Status: Delivered
0 Kudos

Hi , 

 

BI Power not supporting Kerberos authentication to connect to Hadoop , 

 

PLease enable this asap , we are checking for another BI tool as BI power don't have this connectivity setup.

 

our Hadoop platoform is atuhincated by Kerberos.

 

Status: Delivered
0 Kudos

Excel don't connect with Power BI

Status: Accepted
by Leandro Frequent Visitor on ‎03-11-2017 10:58 PM

Some people in my company are having trouble updating Power BI data through excel, for no apparent reason users lose data access, and when they try to connect they get a connection error message.

All users are able to access the data through the browser, but they are not able to access through excel, PBI Publisher is updated, but users receive numerous screens asking for login, but nothing happens, many employees with this problem.

 

Has anyone else had this problem?

Status: Accepted
0 Kudos

I am receiving this cryptic error when trying to update a Desktop (pbix) dataset using the Power BI server (on a personal gateway). The pbix file contains connections to ODBC data merged with SharePoint (Excel) files. Some of the ODBC tables are retrieved and formatted using a table-valued Power Query function. All of this works fine in Power BI Desktop but I receive this weird error in the Power BI service.

 

Any ideas?

 

 

 

Full error details:

 

Data source type: 
Processing error:We cannot convert the value "[Function]" to type Function.
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:c90096fc-14bc-4590-8c87-89155570b7a6
Request ID:6e7a151d-501c-69c7-787d-77ecf4d46df0
Time:2017-01-05 20:27:49Z
Status: Needs Info
0 Kudos

Power BI desktop - unable to connect

Status: New
by Alia New Member on ‎12-02-2016 02:56 AM

Hi BI community, 

 

I have a huge problem with Power BI desktop and I hope you guys can help me to deal with it...

 

I started to use the BI pro version one week ago and I've noticed few error messages. It was ok in the beginning since it only required to close and open the software again but today I got this weird error message talking about connexions channels.

 

I tried to close and open again Power BI but my laptop (which is pretty new - ASUS R457U bought it one week ago in order to use BI since there is no Mac version) turned very slow and I couldnt do anything.

 

Then, I changed my strategy and decided to stop and start again the laptop, same result. Finally, I decided to desinstall and reinstall BI but surprinsgly, it doesn't work at all. I keep receiving this weird message talking about channels connexions that makes me wondering if the problem comes from BI or my computer.

 

Does anyone have the same issue or can help me clarify the situation ?

 

Cheers,

 

Alia

 

 
0 Kudos

Cannot create a group

Status: Delivered
by AndrewSEA Visitor on ‎04-20-2017 12:38 PM

I want to create a group workspace so we can share the dataset (as described in the April release).

 

However, when trying to create workgroup Ikeep getting the below error.  I'm at MSFT, so I get the pro-license.

 

Not sure what to do.

WorkGroupError.JPG

Status: Delivered
0 Kudos

see the error below in the link and suggest what needs to be done:

 

https://community.powerbi.com/t5/Service/On-premise-data-gateway-SQL-server-authentication-error/m-p...

 

Status: Delivered